almost 4 years ago

於DB內建立底下觸發程式 Tigger

CREATE OR REPLACE TRIGGER Schema.TRG_CTMS_SESSION_SETTING
AFTER LOGON
ON DATABASE
BEGIN
    EXECUTE IMMEDIATE 'alter session set nls_comp=linguistic';  
    EXECUTE IMMEDIATE 'alter session set nls_sort=tchinese_stroke_m_ci';
    EXECUTE IMMEDIATE 'alter session set optimizer_mode=choose';
EXCEPTION 
    WHEN OTHERS THEN NULL;
END;
← URL的長度限制 Chrome Console API 小技巧 →
 
comments powered by Disqus