练习oracle时create了很多表,drop表后select * from tab;网上找了好些方法,但是好多都适用...SQL>purge recyclebin;回收站已清空。 Read More
posted @ 2015-03-19 21:45 凌晨灵修 Views(465) Comments(0) Diggs(0) Edit
高级查询随机返回5条记录select * from (select ename,job from emp order bydbms_random.value())where rownume1.sal)1;数据字典查询某用户下所有表select table_name fom all_tables wh... Read More
posted @ 2015-03-19 20:23 凌晨灵修 Views(254) Comments(0) Diggs(0) Edit