Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oralce µÄÒ»¸öSQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÊÌâÌá³ö£º

Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ 
¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬
A B
1 2
2 3
3 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ÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ