ice world

There is nothing too difficult if you put your heart into it.

posts - 104, comments - 103, trackbacks - 0, articles - 0

Oracle左(外)、右(外)、全(外)、(內(nèi))連接語法與SQL標(biāo)準的比較

Posted on 2011-04-18 13:32 IceWee 閱讀(262) 評論(0) 編輯收藏所屬分類: Database

話不多說，請看代碼！

/** left (outer) join */

/** Standard SQL Syntax */

select * from a left outer join b on a.id = b.id;

/** Oracle SQL Syntax */

select * from a, b where a.id = b.id(+);

/** right (outer) join */

/** Standard SQL Syntax */

select * from a right outer join b on a.id = b.id;

/** Oracle SQL Syntax */

select * from a, b where a.id(+) = b.id;

/** (inner) join */

/** Standard SQL Syntax */

select * from a inner join b on a.id = b.id;

/** Oracle SQL Syntax */

select * from a, b where a.id = b.id;

/** (full) join */

/** Standard SQL Syntax */

select * from a full join b on a.id = b.id;

/** Oracle SQL Syntax */

select * from a, b where a.id = b.id(+) union select * from a, b where a.id(+) = b.id;


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: Oracle查詢鎖表以及殺會話或系統(tǒng)進程來解除鎖表操作 Oracle數(shù)據(jù)庫修改字符集 Linux 64bit下Oracle11g安裝手冊 ORA-12516 ORA-12520 PowerDesigner中一些有用的設(shè)置 Windows環(huán)境下Oracle備份還原命令 win7(windows 7)系統(tǒng)下安裝SQL2005(SQL Server 2005)圖文教程 Oracle左(外)、右(外)、全(外)、(內(nèi))連接語法與SQL標(biāo)準的比較 Oracle分頁SQL UNION和UNION ALL的區(qū)別