SELECT ABS(MOD(DBMS_RANDOM.RANDOM,1000)) id from table_dual where id not in
(select id from table_dual)
(select id from table_dual)
解决方案 »
- 历史数据的处理让人头疼
- CTX_REPORT.INDEX_SIZE() 的错误
- 一个SQL错误,谁能帮我看看,急啊~~
- ORACLE中关于时间的差值的困惑
- 克隆数据库时,创建控制文件问题
- 是不是触发器里面 变量能不能作为一个SQL语句的条件?
- 求助:关于Oracle9i中的全文索引的问题!!!来者有分!!!谢了先!!!
- select into 问题
- 请问:怎样在oracle数据库中查出最后10列数据出来按正序排列?
- 求助:oracle703和816共存的办法!
- oracle包,函数,过程,游标的使用
- oracle jdbc 遇到的问题 ORA-12505, TNS:listener does not currently know of SID
minus
select distinct a from tmp_table where a between 1 and 1000
from (select level l from dual connect by level < 1000) t
where l not in (select distinct l from table_name)
with simo_sd as
(select 1 as id from dual
union all
select 2 from dual
union all
select 3 from dual
union all
select 19 from dual
union all
select 433 from dual)--查询语句
select min(lv)
from (select level as lv from dual connect by level <= 999) d
where not exists (select 1 from simo_sd f where d.lv = f.id);