Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì
Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì
1.ÈÕÆÚת»»
Oracle£º TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDD'))
SqlServer£ºCAST(CONVERT(CHAR(8),GETDATE(), 112) AS INT)
×¢£ºÆäÖБYYYYMMDD’¸ñʽ ¶ÔÓ¦112
2.ROWIDת»»
Oracle£º ROWID
SqlServer: PRIMARY KEY(±íÖ÷¼ü)
3.ROWNUM
Oracle£º ROWNUM = 1
SqlServer£º Top 1
×¢£ºÒ»°ãSelectÖеÄÕâ¸ö¿ÉÒÔÖ±½ÓÌæ»»£¬µ«ÊÇÔÚUpdateÖоͱȽÏÄÑÁË£¬ÈçÏ£º
Oracle£º UPDATE ITEM_MST SET
HISD_FLAG = 1
WHERE
ROWID = C2.ROWID;
Sqlserver : UPDATE ITEM_MST SET
HISD_FLAG = 1 --AND ROWNUM = 1 ---KEY
WHERE ITEM_CD IN --=
(SELECT TOP 1 ITEM_CD from ITEM_MST WHERE SALES_NO = @C1_ITEM_NAME )
Ò²¾ÍÊÇ˵£¬¿ÉÒÔÀûÓøÃÐÐÖÐÆäËûµÄÒÑÖªÐÅÏ¢»ñÈ¡¸ÃÏîÊý¾Ý¡£
¡£¡£¡£¡£¡£¡£
£¨Î´Í꣬´ýÐø¡££©
Ïà¹ØÎĵµ£º
Ò»¡¢»ù±¾µÄOracle´æ´¢½á¹¹£º±í¿Õ¼äÓëÊý¾ÝÎļþ
OracleÊý¾Ý¿âÖоßÓÐÁ½ÖÖÀàÐ͵Ĵ洢£ºÎïÀí´æ´¢ºÍÂß¼´æ´¢¡£
ÉÏÃæµÄOracle´æ´¢½á¹¹Ä£ÐÍÖУ¬¿ÉÒÔ¿´³öÏÂÁÐÒªËØ£º
ÿ¸öÊý¾Ý¿â£¨Database£©¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¨Tablespace£©×é³É¡£Ã¿¸ö±í¿Õ¼ä¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸öÊý¾Ý¿â¡£
ÿ¸ö±í¿Õ¼ä¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ£¨Dat ......
1¡¢Oracle NetÓëͨÐÅÐÒé¼ò½é
OracleµÄÍøÂçÖ§³Ö±»ÏÞÖÆÓÚTCP¡¢ÃüÃû¹ÜµÀ£¨Named Pipes£¬¼òдSDP£©¡£ËùÓеIJÙ×÷ϵͳ¶¼¾ßÓÐÒ»¸ö±¾²Ù×÷ϵͳרÓеĽø³Ì¼äͨÐÅ£¨Inter-Process Communication£¬¼òдIPC£©ÐÒé¡£
2¡¢½¨Á¢»á»°
ͨ¹ýÓû§½ø³Ì½¨Á¢Õë¶ÔʵÀýµÄ»á»°£¬¿ÉÒÔÖ´ÐУº
?[Copy to clipboard]View Code SQL
SQL> connect s ......
1¡¢»Ö¸´½á¹¹Óë½ø³Ì
ÔÚ½éÖÊʧ°Üºó£¬¸ù¾ÝÊÜËðÎļþµÄÀàÐÍ£¬´æÔÚ²»Í¬µÄ»Ö¸´·½·¨¡£Êý¾Ý¿âÓÉ¿ØÖÆÎļþ¡¢Áª»úÖØ×öÈÕÖ¾ÎļþÒÔ¼°Êý¾ÝÎļþ×é³É¡£Èç¹û¸´ÓÃÁË¿ØÖÆÎļþ»òÁª»úÖØ×öÈÕÖ¾Îļþ£¬ÄÇô»Ö¸´ÊÜËðµÄÕâЩÎļþÊ®·ÖÈÝÒס£
¶ÔÓÚÊÜËðµÄ¿ØÖÆÎļþ£¬¿ÉÒÔ½«ÆäÌ滻Ϊij¸ö¸´Óø±±¾£¬Ò²¿ÉÒÔʹÓÃCREATE CONTROLFILEÃüÁîÖؽ¨¡£
ÊÜËðµÄÁª»úÖØ×öÈ ......
µ½Oralce·¾¶ÏÂ
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
ZHG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = leehong)(PORT = 1521))
)
(CONNECT_DATA =
& ......
OracleÖÐTO_DATE¸ñʽ
url:http://www.cnblogs.com/ajian/archive/2009/03/25/1421063.html
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½ ......