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

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y                        
CITY     VARCHAR2(20) Y                        
SQL> select * from test;
COUNTRY               CITY
-------------------- --------------------
Öйú                  ̨±±
Öйú                  Ïã¸Û
Öйú                  ÉϺ£
ÈÕ±¾                  ¶«¾©
ÈÕ±¾                  ´óÚæ
ÒªÇóµÃµ½ÈçϽá¹û¼¯£º
-------     --------------------
Öйú        ̨±±,Ïã¸Û,ÉϺ£
ÈÕ±¾        ¶«¾©£¬´óÚæ
   ʵ¼Ê¾ÍÊǶÔ×Ö·ûʵÏÖÒ»¸ö¾ÛºÏ¹¦ÄÜ£¬Î񼆮æ¹ÖΪʲôOracleûÓÐÌṩ¹Ù·½µÄ¾ÛºÏº¯ÊýÀ´ÊµÏÖËüÄØ£º£©
   ÏÂÃæ¾Í¶Ô¼¸ÖÖ¾­³£Ìá¼°µÄ½â¾ö·½°¸½øÐзÖÎö£¨ÓÐÒ»¸öÆÀ²â±ê×¼×î¸ß¡ï¡ï¡ï¡ï¡ï£©£º
1.±»¼¯ºÏ×ֶη¶Î§Ð¡Çҹ̶¨ÐÍ Áé»îÐÔ¡ï    ÐÔÄÜ¡ï¡ï¡ï¡ï ÄÑ¶È ¡ï
   ÕâÖÖ·½·¨µÄÔ­ÀíÔÚÓÚÄãÒѾ­ÖªµÀCITY×ֶεÄÖµÓм¸ÖÖ£¬ÇÒ»¹²»ËãÌ«¶à£¬Èç¹ûÌ«¶àÕâ¸öSQL¾Í»áÏ൱µÄ
³¤¡£¡£¿´Àý×Ó£º
SQL> select t.country,
   2   MAX(decode(t.city,'


Ïà¹ØÎĵµ£º

OracleºÍSQL serverµÄÊý¾ÝÀàÐͱȽÏ


ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ
CHAR
CHAR
¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ
VARCHAR2
VARCHAR
OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®
NCHAR
NCHAR
ǰÕß×î´ó³¤¶È2kbºóÕß×î´ó³¤¶È4 ......

Oracle×Ö·û´®³¤¶ÈµÄÎÊÌâ

    ½ñÌìÅöµ½Ò»¸öÎÊÌ⣬ͨ¹ýÒ»¸öSQLÓï¾ä²éѯʱ£¬³öÈçÏÂÎÊÌ⣺
       ORA-06502: PL/SQL: numeric or value error: character string buffer too small
       ORA-06512: at "WMSYS.WM_CONCAT_IMPL", line 30
 ÎÊÌâ³öÏÖÔÚͨ¹ýWMSYS. ......

oracleÇ¨ÒÆ±í¿Õ¼ä

¿ÉÇ¨ÒÆ±í¿Õ¼ätransport tablespace
¿ÉÇ¨ÒÆ±í¿Õ¼ä
ʹÓÿÉÇ¨ÒÆ±í¿Õ¼ä(Transportable Tablespaces)µÄÌØÐÔÔÚÊý¾Ý¿âÖ®¼äÒÆ¶¯´óÁ¿Êý¾Ý£¬ÐÔÄܱÈexport/importºÍunload/loadÒª¿ìºÜ¶à£¬ÒòΪËüÇ¨ÒÆ±í¿Õ¼äÖ»ÐèÒª¸´ÖÆÊý¾ÝÎļþºÍ²åÈë±í¿Õ¼äÔªÊý¾Ýµ½Ä¿±êÊý¾Ý¿âÖС£
Ç¨ÒÆ±í¿Õ¼ä¶ÔÒÔÏÂÓ¦ÓÃÌØ±ðÓÐÓãº
·Ö½×¶Î½«OLTPµÄÊý¾ÝÒÆÈëÊý¾Ý²Ö¿â
¸ ......

oracleÖеÄsavepointsÊÇʲô

ʲôÊÇsavepoint?
Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.
¸øÄã¸öÀý×Ó 
SQL> create table test (id number(7)); 
±íÒÑ´´½¨¡£ 
SQL> insert into test values (3); 
ÒÑ´´½¨ 1 ÐС£ 
SQL> savepoint a; 
±£´æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ