练习oracle时create了很多表,drop表后select * from tab;网上找了好些方法,但是好多都适用...SQL>purge recyclebin;回收站已清空。 Read More
高级查询随机返回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