-
编辑 删除
undo_redo_generate_volumn_test
1.query undo_redo before size.(use view is convenience)点击(此处)折叠或打开CREATE OR REPLACE VIEW 点击(此处)折叠或打开select * from V_REDO_UNDO_volumn.ASSELECT ...
-
编辑 删除
set echo on/off example
1.create echo.sql script with content in the following text点击(此处)折叠或打开set echo on select ename from emp where rownum <2;set echo off --这后面的查询语句不会显示出来select dname from dept where rownum <22.execute ...
-
编辑 删除
如何一条语句删除多张表
第一种方法：SCOTT@PROD> select 'drop table '|| table_name ||';' from user_tables;'DROPTABLE'||TABLE_NAME||';'------------------------------------------drop table DEPT;drop table EMP;drop table BONUS;drop table SALGRADE;drop table T1;drop table DEPT1;drop table EMP1;drop table TBS1;drop ...
-
编辑 删除
如何查寻数据库中多张表的总数
SELECT ( SELECT COUNT(*) FROM tab1 ) AS count1, ( SELECT COUNT(*) FROM tab2 ) AS count2 FROM dual
