我們這里還有魚

Oracle的JDBC連接

根據(jù)實際情況填寫，格式為
對于非RAC數(shù)據(jù)庫：jdbc:oracle:thin:@10.137.31.147:1521:showtibco
對于RAC數(shù)據(jù)庫：：jdbc:oracle:thin:@(DESCRIPTION = (ENABLE=BROKEN) (LOAD_BALANCE=OFF) (FAILOVER=ON) (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.166.180 )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.166.181 )(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = esbora ) (FAILOVER_MODE= (TYPE=SELECT) (METHOD=BASIC) ) ) )



http://www.aygfsteel.com/DyEnigma/articles/352773.html


CREATE PROCEDURE restockPro(IN init INT, IN loop_time INT)
    BEGIN
    DECLARE Var INT;
    DECLARE ID INT;
    SET Var = 0;
    SET ID = init;
    WHILE Var < loop_time DO
    INSERT INTO news VALUES(ID, '今天天氣好晴朗');
    SET ID = ID + 1;
    SET Var = Var + 1;
    END WHILE;
    END;


http://www.aygfsteel.com/rongxh7/archive/2008/11/29/243456.html

posted @ 2011-10-18 17:04 不服輸?shù)墓饭?閱讀(379) | 評論 (0) | 編輯 收藏