81. 内连接inner join?
) C- d' L/ n1 U/ Pselect a.* from bsempms a,bsdptms b where a.dpt_no=b.dpt_no;
' w6 z7 j1 T C: v, i4 j u9 J5 b+ K' [" A9 ~* ]/ j: M) p
82. 如何外连接? + x$ X3 C) d& ~3 r0 |
select a.* from bsempms a,bsdptms b where a.dpt_no=b.dpt_no(+); $ f" W* k0 Z% S+ _
select a.* from bsempms a,bsdptms b wherea.dpt_no(+)=b.dpt_no; 8 q* A% @$ d+ @& Q1 m! X. i
: J/ E0 m0 Y: M
83. 如何执行脚本sql文件?
: @5 i: {2 l2 j9 Zsql>@$path/filename.sql; - l. Z( W" W- G, ]2 d: _# h
& o# f& H2 Y l7 s) `. y+ m' C84. 如何快速清空一个大表?
* I, n ?$ `: C8 i% Ysql>truncate table table_name;
; z- M& D0 ~$ R X+ v5 y' F 5 u% M( z$ r1 s) V# K
85. 如何查有多少个数据库实例? * v9 U" Q, }8 u s. \3 O
sql>select * from v$instance; |