https://blog.csdn.net/badyflfzh-cnhttps://blog.csdn.net/https://blog.csdn.net/badyflf/article/details/51220141https://blog.csdn.net/badyflf/article/details/51220141badyflfFri, 22 Apr 2016 14:47:50 +0800https://blog.csdn.net/badyflf/article/details/51211530https://blog.csdn.net/badyflf/article/details/51211530badyflfThu, 21 Apr 2016 18:15:16 +0800 select t.sid, t.sname 2 from t_student t 3 where t.sid not in 4 (select distinct t.sid 5 from t_score t 6 where t.cid in 7 (select t.]]>https://blog.csdn.net/badyflf/article/details/51208182https://blog.csdn.net/badyflf/article/details/51208182badyflfThu, 21 Apr 2016 13:23:34 +0800https://blog.csdn.net/badyflf/article/details/51163696https://blog.csdn.net/badyflf/article/details/51163696badyflfFri, 15 Apr 2016 18:03:24 +0800 select t.object_id from t_distinct_tb t ; 已选择50631行。 已用时间: 00: 00: 00.71 执行计划 -----------------------------------------------------]]>https://blog.csdn.net/badyflf/article/details/51163314https://blog.csdn.net/badyflf/article/details/51163314badyflfFri, 15 Apr 2016 17:20:18 +0800 set autotrace traceonly; SQL> select * from t_order_tb t where t.object_id > 2 ; 已选择50628行。 已用时间: 00: 00: 02.25 执行计划 ---------------------------------------------------------- Plan hash value]]>https://blog.csdn.net/badyflf/article/details/51162359https://blog.csdn.net/badyflf/article/details/51162359badyflfFri, 15 Apr 2016 15:57:38 +0800https://blog.csdn.net/badyflf/article/details/51161664https://blog.csdn.net/badyflf/article/details/51161664badyflfFri, 15 Apr 2016 15:06:46 +0800https://blog.csdn.net/badyflf/article/details/51161514https://blog.csdn.net/badyflf/article/details/51161514badyflfFri, 15 Apr 2016 14:34:44 +0800https://blog.csdn.net/badyflf/article/details/51160849https://blog.csdn.net/badyflf/article/details/51160849badyflfFri, 15 Apr 2016 12:59:14 +0800 show parameter cache_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_16k_cache_size]]>https://blog.csdn.net/badyflf/article/details/51159333https://blog.csdn.net/badyflf/article/details/51159333badyflfFri, 15 Apr 2016 10:10:38 +0800 select x from t where x = 4523423; --第一次执行 已用时间: 00: 00: 00.15 执行计划 ---------------------------------------------------------- Plan hash value: 1572208108 -----------------------------------]]>https://blog.csdn.net/badyflf/article/details/51153865https://blog.csdn.net/badyflf/article/details/51153865badyflfThu, 14 Apr 2016 18:11:16 +0800https://blog.csdn.net/badyflf/article/details/51150652https://blog.csdn.net/badyflf/article/details/51150652badyflfThu, 14 Apr 2016 12:45:06 +0800https://blog.csdn.net/badyflf/article/details/51150211https://blog.csdn.net/badyflf/article/details/51150211badyflfThu, 14 Apr 2016 11:35:01 +0800 select t1.empno, t1.ename, t2.deptno, t2.dname from emp t1, dept t2 where t1.deptno = t2.deptno(+); EMPNO ENAME DEPTNO DNAME---------- ---------- ---------- -------------- 7369 SMITH 20 RESEARCH]]>https://blog.csdn.net/badyflf/article/details/51145330https://blog.csdn.net/badyflf/article/details/51145330badyflfWed, 13 Apr 2016 17:39:50 +0800https://blog.csdn.net/badyflf/article/details/51141492https://blog.csdn.net/badyflf/article/details/51141492badyflfWed, 13 Apr 2016 11:09:15 +0800https://blog.csdn.net/badyflf/article/details/51137849https://blog.csdn.net/badyflf/article/details/51137849badyflfTue, 12 Apr 2016 22:27:26 +0800https://blog.csdn.net/badyflf/article/details/51133640https://blog.csdn.net/badyflf/article/details/51133640badyflfTue, 12 Apr 2016 15:09:11 +0800https://blog.csdn.net/badyflf/article/details/51132684https://blog.csdn.net/badyflf/article/details/51132684badyflfTue, 12 Apr 2016 13:48:02 +0800https://blog.csdn.net/badyflf/article/details/51097552https://blog.csdn.net/badyflf/article/details/51097552badyflfFri, 08 Apr 2016 16:17:35 +0800https://blog.csdn.net/badyflf/article/details/51036999https://blog.csdn.net/badyflf/article/details/51036999badyflfFri, 01 Apr 2016 15:05:11 +0800