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 )
Ò²¾ÍÊÇ˵£¬¿ÉÒÔÀûÓøÃÐÐÖÐÆäËûµÄÒÑÖªÐÅÏ¢»ñÈ¡¸ÃÏîÊý¾Ý¡£
¡£¡£¡£¡£¡£¡£
£¨Î´Í꣬´ýÐø¡££©
Ïà¹ØÎĵµ£º
Ò»¡¢SQLµÄʹÓÃ
CREATE¡¢ALTERºÍDROPÊÇÖ÷ÒªµÄ3ÖÖDDLÓï¾ä£¬ÕâЩÓï¾ä±»ÓÃÓÚÔÚÊý¾Ý¿âÖÐÌí¼Ó¡¢Ð޸Ļòɾ³ý¶ÔÏó¡£
DCLÓï¾ä°üÀ¨GRANTºÍREVOKEÃüÁËüÃÇ¿ÉÒÔ±»ÓÃÓÚΪÓû§»ò½ÇÉ«ÊÚÓè»òÈ¡ÏûȨÏÞ£¬¿ÉÒÔ±»ÊÚÓèºÍÈ¡ÏûµÄÁ½ÖÖȨÏÞÊÇϵͳȨÏ޺ͶÔÏóȨÏÞ¡£È¡¾öÓÚ²»Í¬µÄ¶ÔÏóÀàÐÍ£¬¶ÔÏóȨÏÞ¿ÉÄܲ»Í¬¡£
²Ù×Ý»ò¼ìË÷Êý¾Ý¶¼ÐèҪʹÓÃDMLÓï¾ä¡£D ......
1¡¢µ÷ÕûĬÈϵݲȫÉèÖÃ
1.1¡¢Ä¬ÈϵÄÓû§
²é¿´Êý¾Ý¿âµÄÓû§ºÍ״̬£¬¿ÉÒÔ²éѯDBA_USERSÊÓͼ¡£
?[Copy to clipboard]View Code SQL
SQL> select username,account_status from dba_users;
1.2¡¢PUBLICȨÏÞ
OracleÖдæÔÚÒ»¸öÃûΪPUBLICµÄαÓû§¡£Ö»ÒªÓÃPUBLICÊÚÓèij¸öȨÏÞ£¬ÄÇôËùÓÐÓû§¶¼»á±»ÊÚÓèÕâ¸öȨÏÞ¡£
?[Copy ......
ORA-00001: Î¥·´Î¨Ò»Ô¼ÊøÌõ¼þ (.)
ORA-00017: ÇëÇó»á»°ÒÔÉèÖøú×Ùʼþ
ORA-00018:
³¬³ö×î´ó»á»°Êý
ORA-00019: ³¬³ö×î´ó»á»°Ðí¿ÉÊý
ORA-00020: ³¬³ö×î´ó½ø³ÌÊý ()
ORA-
00021: »á»°¸½ÊôÓÚÆäËüijЩ½ø³Ì£»ÎÞ·¨×ª»»»á»°
ORA-00022: ÎÞЧµÄ»á»° ID£»·ÃÎʱ»¾Ü¾ø
ORA-00023:
»á»°ÒýÓýø³Ì˽ÓÃÄڴ棻ÎÞ·¨·ÖÀë»á» ......
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 Á½ ......
oracle clob ºÍblobÎÊÌâµÄ½â¾ö
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£»
2£ºspringÅäÖÃÈçÏ£º
java´úÂë:
<bean id="sessionFact ......