-
编辑 删除
关于外连接的一个实验(先过滤后连接，先连接后过滤)
[@more@]Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as mr========建立测试表WT1，WT2SQL> drop TABLE wt1;Table droppedSQL> drop TABLE wt2;Table droppedSQL> create TABLE wt1(x NUMBER, y NUMBER);Table createdSQL> SQL> INSERT INTO wt1 SELECT 1,11 from dual;1 row insertedSQL> INSERT INTO wt1 SELECT 2,22 from dual;1 row insertedSQL> commit;Commit completeSQL> create TABLE wt2(x NUMber,y NUMBER ,z NUMBER);Table createdSQL> SQL> INSERT IN
-
编辑 删除
oracle internal 研究的相关网址
http://www.ixora.com.au/http://www.jlcomp.demon.co.uk/http://blog.tanelpoder.comhttp://www.juliandyke.comhttp://www.dbazine.com/oracle/ora-articles/http://www.oaktable.net/articleshttp://blog.tanelpoder.com/?s=systemstatehttp://www.pythian.com/news/[@more@]
