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

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 )
      Ò²¾ÍÊÇ˵£¬¿ÉÒÔÀûÓøÃÐÐÖÐÆäËûµÄÒÑÖªÐÅÏ¢»ñÈ¡¸ÃÏîÊý¾Ý¡£
¡£¡£¡£¡£¡£¡£
£¨Î´Í꣬´ýÐø¡££©


Ïà¹ØÎĵµ£º

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨6£©£º¹ÜÀíOracle´æ´¢½á¹¹

Ò»¡¢»ù±¾µÄOracle´æ´¢½á¹¹£º±í¿Õ¼äÓëÊý¾ÝÎļþ
OracleÊý¾Ý¿âÖоßÓÐÁ½ÖÖÀàÐ͵Ĵ洢£ºÎïÀí´æ´¢ºÍÂß¼­´æ´¢¡£
ÉÏÃæµÄOracle´æ´¢½á¹¹Ä£ÐÍÖУ¬¿ÉÒÔ¿´³öÏÂÁÐÒªËØ£º
ÿ¸öÊý¾Ý¿â£¨Database£©¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¨Tablespace£©×é³É¡£Ã¿¸ö±í¿Õ¼ä¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸öÊý¾Ý¿â¡£
ÿ¸ö±í¿Õ¼ä¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ£¨Dat ......

oracle clob ºÍblobÎÊÌâµÄ½â¾ö

oracle clob ºÍblobÎÊÌâµÄ½â¾ö
 
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£» 
2£ºspringÅäÖÃÈçÏ£º 
java´úÂë: 
        <bean id="sessionFact ......

WIN7ÏÂÔõÑù×°Oracle 10g

      
WIN7µÄϵͳ½çÃæºÜƯÁÁ£¬Ê¹ÓÃÆðÀ´È·ÊµºÜ²»´í£¬¿ÉÊÇÈ´Ò²¸øÎÒµÄѧϰ´øÀ´¹ý²»ÉÙÂé·³¡£ÓÈÆäÊÇÕâ´Î×°Oracle£¬±ðÈËÓõÄÊÇXPµÄϵͳºÜÈÝÒ×¾Í×°ÉÏÁ˵ģ¬¿ÉÊÇÎÒÈ´ÔõôҲװ²»ÉÏ¡£ÎªÁËÈÃͬÑùϲ°®WIN7µÄÅóÓÑÉÙ×ßЩÍä·£¬ÏÂÃæ¾Í½éÉÜÒ»ÏÂÔÚwin7ÉÏ°²×°Oracle10gµÄ·½·¨°É£¬ÄÇ¿ÉÊDZ¾ÈËÓÃÁË8Ììʱ¼ä£¬²»Í ......

Oracle Sql ÐÔÄÜÓÅ»¯

1£©²»Öª´ó¼ÒÊÇ·ñϲ»¶Ê¹ÓÑNOT IN’ÕâÑùµÄ²Ù×÷£¬Èç¹ûÊÇ£¬ÄǾ¡Á¿Ê¹ÓÃ(NOT) EXISTS Ìæ´ú
2£©ÔÚº£Á¿²éѯʱ¾¡Á¿ÉÙÓøñʽת»»¡£
3£©²éѯº£Á¿Êý¾ÝÊÇ£¬¿ÉÒÔʹÓÃoptimizer['ɔptimaizə] hints£¬ÀýÈç/*+ORDERED */
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ