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

Oracle ʵÏÖÐÐÁÐת»»

SQL> DESC TEST  ²âÊÔ±í:        Name    Type            Nullable    Default Comments
       ----     ------------         --------      -------     --------
       A        NUMBER           Y                        
       B        VARCHAR2(20) Y          SQL> select * from test;                  A B
       ---------- --------------------
                 1 a
                 1 b
                 1 c
                 1 d
                 1 e
                 2 a
                 2 b
                 3 a
         


Ïà¹ØÎĵµ£º

ORACLE ³£ÓÃ×Ö·ûº¯Êý


1.LOWER(str) Ç¿ÖÆÐ¡Ð´
2.UPPER(str) Ç¿ÖÆ´óд
3.INITCAP(str) ÿ¸öµ¥´ÊÊ××Öĸ´óд
ʾÀý£º
SQL> select initcap('my_boy') from dual; --·µ»Ø"My_Boy"
×¢Ò⣺µ¥´ÊÖ®¼äÓÃÏ»®Ïߣ¨"_"£©·Ö¸î
4.CONCAT(str1,str2£©Á¬½Óº¯Êý,Á¬½Óstr1ºÍstr2×Ö·û´®
5.SUBSTR(string,a[,b])·µ»ØstringµÄÒ»²¿·Ö£¬aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó× ......

OracleÖеÄRawÀàÐͽâÊÍ

RAW£¬ÀàËÆÓÚCHAR£¬ÉùÃ÷·½Ê½RAW(L)£¬LΪ³¤¶È£¬ÒÔ×Ö½ÚΪµ¥Î»£¬×÷ΪÊý¾Ý¿âÁÐ×î´ó2000£¬×÷Ϊ±äÁ¿×î´ó32767×Ö½Ú¡£
¡¡¡¡LONG RAW£¬ÀàËÆÓÚLONG£¬×÷ΪÊý¾Ý¿âÁÐ×î´ó´æ´¢2G×Ö½ÚµÄÊý¾Ý£¬×÷Ϊ±äÁ¿×î´ó32760×Ö½Ú
¡¡¡¡½¨±í²Ù×÷:
¡¡¡¡create table raw_test (id number, raw_date raw(10));
¡¡¡¡²åÈërawÊý¾Ý²Ù×÷:
¡¡¡¡insert into raw ......

OracleÓÃimpµ¼ÈëÓû§±íʱѡÔñ±í¿Õ¼äµÄÎÊÌâ

×Ô¼º¾õµÃ¶ÔOracle»¹ÕÆÎյò»´í£¬²»¹ý×òÌì¸ô±ÚʵÑéÊÒµÄͬѧÎÊÁËÎÒÒ»¸öÎÊÌâÈÃÎÒÓôÃÆÁËÒ»°Ñ¡£ËýÔÚÒ»¸öÊý¾Ý¿âÀï°ÑÒ»¸öÓû§AµÄÔÚ±í¿Õ¼äAAÉϵıí
ÓÃexpµ¼³öµ½exp.dmpÎļþÖУ¬ÔÙ°ÑËüµ¼Èëµ½Áíһ̨»úÆ÷ÉϵÄÊý¾Ý¿âÀÕâʱËýÓõÄÊÇÓû§B£¬Ä¬Èϱí¿Õ¼äÊÇBB£¬µ«ÊÇÓÃimpµ¼ÈëʱÎÒÃÇ·¢ÏÖ±íÊǵ¼Èë
µ½ÁËBÓû§Ï£¬µ«ÊÇ»¹ÊÇ´æÔÚÁËAA±í¿Õ¼äÀïÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ