oracle11g使用小技巧（汇总）

 1）查看SQL执行操作时间

显示大概时间：set time on/off
显示精确时间：set timing on/off

示例如下

SQL> set time on    
15:16:06 SQL> select * from test;

NAME                                                 ID             MALE
-------------------- ---------- ----------
jack                                 1234567890                    1

Elapsed: 00:00:00.44
15:16:12 SQL> set time off
SQL> set timing on
SQL> select * from test;

NAME                                                 ID             MALE
-------------------- ---------- ----------
jack                                 1234567890                    1

Elapsed: 00:00:00.00
SQL> set timing off
SQL>    

2）