oralce µÄÒ»¸öSQL - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÊÌâÌá³ö£º Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ ¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬ A B 1 2 2 3 3 4 4 ÓÐÕâÑùһЩÊý¾Ý ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý COLA COL1 COL3 COL2 COL1 4 4 3 2 1 ¾ÍÊÇ˵£¬AºÍBµÄÊý¾Ý±íʾһÖÖÁ¬½ÓµÄ¹ØÏµ£¬ÏÖÔÚÏëͨ¹ýAµÄÒ»¸öÖµ£¬È¥²éѯAËù¶ÔÓ¦µÄBÖµ£¬Ö±µ½BΪNULLΪֹ£¬È»ºó°´ÕÕ¸ùµ½Ò¶×ÓÏÔʾ
ʵÔÚÊÇû¿´¶®¡£¡£¡£ 4Ôõô¶ÔÓ¦4 3 2 1µÄÄØ£¿ ȷʵ ÌâÄ¿¿´¶®ÁË£¬²»¹ý²»ÖªµÀÔõôʵÏÖ Ã»¿´Ì«Ã÷°× ÄãÄǸöCOLA COL1 COL3 COL2 COL1·Ö±ð´ú±íʲôÒâ˼ COLA¾ÍÊÇÖ¸¶¨µÄAÁеÄÖµ?ÒýÓà û¿´Ì«Ã÷°× ÄãÄǸöCOLA COL1 COL3 COL2 COL1·Ö±ð´ú±íʲôÒâ˼ COLA¾ÍÊÇÖ¸¶¨µÄAÁеÄÖµ? COLA ¶ÔÓ¦µÄÊÇ ¸ùµÄÖµ COL4 COL3 COL2 COL1 ÒÀ´ÎÊÇ´Ó¸ùµ½ Ò¶×Ó ÖмäµÄËùÓнڵ㠻òÐíµÃÓõ½pl/sql£¬Ò»Ìõ²éѯÄܺÃÏñ²»Ðаɣ¬ÄÇÁÐÒ²ÊǶ¯Ì¬Ôö³¤µÄ°¡¡£¡£¡£ÒýÓà SQL codewith ttas(select1 a,2 bfrom dualunionallselect2,3from dualunionallselect3,4from dualunionallselect4,nullfrom dualunionallselect5,6from dualunionallselect6,7from dualunionallselect7,8from dualu?- Ò»¸ö¸¸½ÚµãÉÏÈç¹ûÓжà¸ö×Ó½Úµã Ã²ËÆ¾Í²»¶ÔÁ˰¢ ²»»á£¡ °ï¶¥ÁË£¡ û¿´³öÀ´Ëã·¨Âß¼¡£ ¹Ø×¢Ñ§Ï°ÏÂÒýÓà ÒýÓà 6 Â¥ wildwave µÄ»Ø¸´: SQL codewith ttas(select1 a,2 bfrom dualunionallselect2,3from dualunion
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......