measure execution time

忘記在哪邊看到，要計算時間可以用to_char(time, 'sssss')，然後相減


DECLARE
    START_TIME   DATE;
    END_TIME     DATE;
BEGIN
    START_TIME := SYSDATE;
 
--    dbo.LF_GET_PROJECT_PRM_T('TPB72400001',  '20', '', '20110301', '0001760', ' ', 1, 2, 0, 0, 0, 1000000, 0, 100000, 'R880', 'D');

    DBO.JUC7924_7SP(null, null, null, null, 'TPB88S00005', '', '', :RC1); --CAS_P_TRVRAT
 
    END_TIME := SYSDATE;
 
    DBO.OF_INSERT_JUC_10TRANSFER8LOG('1', '', '', 'START TIME:'||START_TIME||', END TIME'||END_TIME, 'EXECUTION TIME:'||(to_char(END_TIME, 'sssss') - to_char(START_TIME, 'sssss')));

END;

SELECT * FROM DBO.TT_LOG;

SELECT * FROM DBO.TT_CAS_P_TRVRAT;