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)
解决方案 »
- 使用oracle把csv文件打成zip包作为附件使用utl_smtp发送邮件的问题
- 数据库 删除 之后重新建立的 问题
- 在已经安装oracle 9i/10g 机器上,再安装遇到的问题
- 关于oracle索引问题
- ORA-01008 有变量没关联
- 问两个 oracle 方面的问题
- 请教:问什么我的Oracle每次重新启动后都不能用了
- 在线急等,有个dmp文件,怎么样恢复成数据库。
- .db是什么文件???
- 我问的问题没有显示,再开一帖,欢迎up
- 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);