oracle½¨¿â½¨±íµÄsqlÓï¾ä
ÎÒ¸Õ´Ósqlserverתµ½oracle,¶Ôoracle²»Êì
ÎÒÃÇÔÚ×öÏîĿʱ£¬ÔÚsqlserverÊý¾Ý¿âÏ£¬×ÜÊÇдһ¸öxx.sqlµÄÎļþ£¬ÕâÑùÔÚsqlserverÏÂÒ»ÔËÐУ¬Êý¾Ý¿â±íºÍÓû§Ê²Ã´¶¼¾Í¶¼ÅªºÃÁË
ÏÖÇóoracleµÄÕâÒ»ÀàËÆxx.sqlµÄÎļþµÄ´úÂ룬×îºÃдעÊÍ£¬ÕâÑùÎÒ¾ÍʲôÁ˽âoracleÒ»µãµãÁË¡£
лл´ó¼Ò
baiduÒ»´ó¶Ñ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÎÒÒ²ÊǸÕÈëOracleµÄÃÅ£¬ÍƼöÂ¥Ö÷Ò»¸ö¹¤¾ßPLSql
¿´¿´oracle»ù±¾µÄ¶«Î÷¾Í¿ÉÒÔ£¬²»±ØÏ¸¾¿
ºÍsqlserver ²î²»¶à£¬ ¾ÍÊÇһЩÀàÐͲ»Ò»Ñù£¬ Äã°Ñsqlserver ·Åµ½OracleÅÜһϾÍÖªµÀÁË¡£
Oracle µÄ¹¤¾ß¿ÉÒÔÓÃPL/SQL DEV »òÕßTOad. ÓÃÕâ2¸ö¹¤¾ßдSQL ЧÂÊÒª¸ßºÜ¶à¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
oracleÖд´½¨±íºÍsqlserverÖÐÒ»Ñù£¬T-SQLÄǸöÊý¾Ý¿â¶¼ÊÇÒ»ÑùµÄ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......