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

Oracle²ð·Ö×Ö·û´®º¯Êý

--¶¨ÒåÀàÐÍ
CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2(4000);
--´´½¨º¯Êý
CREATE OR REPLACE FUNCTION f_stringsplit (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)
    RETURN ty_str_split PIPELINED
/*****
****×Ö·û´®²ð·Ö,Ï൱ÓÚjava.lang.StringÀàµÄsplit·½·¨
****×¢Òâ:ÐÂÔötypes:CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (100);
****´´½¨Õߣº
****ʱ¼ä£º
****ÕªÈ¡ÍøÂç×ÊÔ´
***/
IS
    j INT := 0;
    i INT := 1;
    len INT := 0;
    len1 INT := 0;
    str VARCHAR2 (100);
BEGIN
    len := LENGTH (p_str);
    len1 := LENGTH (p_delimiter);
    WHILE j < len
    LOOP
        j := INSTR (p_str, p_delimiter, i);
        IF j = 0
        THEN
            j := len;
            str := SUBSTR (p_str, i);
            PIPE ROW (str);
            IF i >= len
            THEN
                EXIT;
            END IF;
        ELSE
            str := SUBSTR (p_str, i, j - i);
            i := j + len1;
            PIPE ROW (str);
        END IF;
    END LOOP;
    RETURN;
END f_stringsplit;
--µ÷ÓÃ
select¡¡*¡¡from¡¡t


Ïà¹ØÎĵµ£º

Oracle Tuning

¡¡     ¹ØÓÚOracleµÄÐÔÄܵ÷Õû£¬Ò»°ã°üÀ¨Á½¸ö·½Ã棬һÊÇÖ¸OracleÊý¾Ý¿â±¾ÉíµÄµ÷Õû£¬±ÈÈçSGA¡¢PGAµÄÓÅ»¯ÉèÖ㬶þÊÇÁ¬½ÓOracleµÄÓ¦ÓóÌÐòÒÔ¼°SQLÓï¾äµÄÓÅ»¯¡£×öºÃÕâÁ½¸ö·½ÃæµÄÓÅ»¯£¬¾Í¿ÉÒÔʹһÌ×ÍêÕûµÄOracleÓ¦ÓÃϵͳ´¦ÓÚÁ¼ºÃµÄÔËÐÐ״̬¡£
¡¡¡¡ ±¾ÎÄÖ÷ÒªÊǰÑһЩOracle TuningµÄÎÄÕÂ×÷ÁËÒ»¸ö¼òµ¥µÄ×ܽᣬ ......

OracleÊý¾Ý¿â½â³ýscottÓû§Ëø

1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
      conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......

OracleÊý¾Ý¿âÖеÄËø»úÖÆÑо¿

Êý¾Ý¿âÊÇÒ»¸ö¶àÓû§Ê¹ÓõĹ²Ïí×ÊÔ´¡£µ±¶à¸öÓû§²¢·¢µØ´æÈ¡Êý¾Ýʱ£¬ÔÚÊý¾Ý¿âÖоͻá²úÉú¶à¸öÊÂÎñͬʱ´æÈ¡Í¬Ò»Êý¾ÝµÄÇé¿ö¡£Èô¶Ô²¢·¢²Ù×÷²»¼Ó¿ØÖƾͿÉÄÜ»á¶ÁÈ¡ºÍ´æ´¢²»ÕýÈ·µÄÊý¾Ý£¬ÆÆ»µÊý¾Ý¿âµÄÒ»ÖÂÐÔ¡£
¼ÓËøÊÇʵÏÖÊý¾Ý¿â²¢·¢¿ØÖƵÄÒ»¸ö·Ç³£ÖØÒªµÄ¼¼Êõ¡£µ±ÊÂÎñÔÚ¶Ôij¸öÊý¾Ý¶ÔÏó½øÐвÙ×÷ǰ£¬ÏÈÏòϵͳ·¢³öÇëÇó£¬¶ÔÆä¼ÓËø¡£¼ÓËøºó ......

Oracle ³£ÓÃÍøÖ· »ýÀÛÖС£¡£

¹Ù·½Îĵµ£ºhttp://tahiti.oracle.com/
metalink:http://metalink.oracle.com
itpub:www.itpub.com
TOM:asktom.oracle.com
oracle forum:http://forums.oracle.com/forums/main.jspa?categoryID=84
OTN:http://www.oracle.com/technology/index.html
www.oracle.com.cn
www.eygle.com
 
Oracle ERP
www.erp10 ......

×î½üÔÚ×öOracleÁÙʱ±í¼ÓÔØ ×ªÔØÒ»¸öÒÔ±ã²éѯ

×ªÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data 
and redo logs for the undo logs are generated. Data from the temporary table is automatically 
dropped in the case of session termination, either when the user logs o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ