ÔÚPBÖÐÀûÓÃORACLEµÄÌæ»»º¯ÊýREPLACE
PB×Ô´øµÄREPLACEÓï¾äÓÃ×Å×ÜÓÐЩ²»Ï°¹ß¡£½ñÌìͬÊÂÔÚ×öÊý¾ÝǨÒÆÖУ¬Óõ½Ìæ»»¹¦ÄÜ£¬¸ù¾Ý²»Í¬µÄµÇ¼Óû§£¬Ñ¡Ôñ¸ÃÓû§ÏÂµÄ±í¡£ËùÒÔ£¬ÎÒ¾ÍÓÃORACLEµÄº¯ÊýÀ´ÊµÏÖËü¡£Æäʵͦ¼òµ¥µÄ£¬¾ÍÊÇÒ»¸öPB¶¯Ì¬SQLÓï¾äµÄÀý×Ó¶øÒÑ¡£ÏÂÃæÊǸöÀý×Ó£¬SQLÓï¾ä×ÔÒÑÆ´×°ºÃ¡£×¢ÒâÆ´×°µÄSQLÓï¾äĩβ²»ÒªÏ°¹ßµÄ¼Ó“£»”£¬ÄÇÑùÊÇ´íÎóµÄ¡£
string ls_sql,ls_value
ls_sql = "SELECT REPLACE('MIGRATIONRULE','MIGRATIONRULE','SHANGHAI.MIGRATIONRULE') AS AA from DUAL"
DECLARE self_replace DYNAMIC CURSOR FOR SQLSA ;
PREPARE sqlsa from :ls_sql ;
OPEN DYNAMIC self_replace ;
FETCH self_replace INTO :ls_value;
CLOSE self_replace;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê11ÔÂ08ÈÕ 12:15:21Çë×ðÖØÔ´´×÷Æ·¡£×ªÔØÇë±£³ÖÎÄÕÂÍêÕûÐÔ,²¢ÒÔ³¬Á´½ÓÐÎʽעÃ÷Ôʼ×÷Õß¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±ºÍ³ö´¦¡±http://blog.csdn.net/inthirties/archive/2009/11/08/4786769.aspx¡±,ÉîÈëÌÖÂÛ¿ÉÒÔÁªÏµinthirties@gmail.com¡£ÔÚcsdnÉÏ¿´µ½Ò»¸öÍøÓÑÎʵÄÒ»¸öÎÊÌâ http://topic.csdn.net ......
41.SYSDATE
ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
TO_CHAR(SYSDATE,
-----------------
09-05-2004ÐÇÆÚÈÕ
trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆڽضÏ,È ......
¼òµ¥ÃèÊöÒ»ÏÂÔÚwindowsµÄͬһÓû§Ï£¬°²×°OracleµÄ9i¡¢10gºÍ11gµÄ·½·¨¡£
OracleÔÚwindowsƽ̨ϵݲװÊÇËùÓÐƽ̨ÖÐ×î¼òµ¥µÄ£¬»ù±¾Éϲ»ÐèÒª½øÐÐÈκζîÍâµÄ´¦Àí¾Í¿ÉÒԳɹ¦µÄ°²×°£¬¿ÉÒÔ˵ûÓÐʲô¼¼Êõº¬Á¿¡£
²»¹ýÔÚͬһ̨»úÆ÷µÄͬһ¸öÓû§ÉÏͬʱ°²×°Á½¸ö²»Í¬°æ±¾µÄÊý¾Ý¿â¾ÍÐèÒªÒ»¶¨µÄ¼¼ÇÉÁË¡£ÕâÀï¼òµ¥ÃèÊöÒ»ÏÂÔÚͬʱ ......
£¨1£© varchar2(n):¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´®£¬ÆäÖÐ n ÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ 32767 ×Ö½Ú¡£µ±Ê¹ÓøÃÊý¾ÝÀàÐͶ¨Òå±äÁ¿ÊÇ£¬±ØÐë×¢Ò⣬ÔÚPL/SQL¿éÖÐʹÓøÃÊý¾ÝÀàÐͲÙ×Ývarchar2±íÁÐʱ£¬ÆäÊýÖµµÄ³¤¶È²»Ó¦¸Ã³¬¹ý 4000 ×Ö½Ú¡£
......