CREATE OR REPLACE TRIGGER

发表于:2007-05-25来源:作者:点击数: 标签:TRIGGERCREATEReplace

CREATE OR REPLACE TRIGGER trig_scott_logon_db
after logon on database
begin
if(user='SCOTT') then
execute immediate 'alter session set nls_language=american';
end if;
end;
/

原文转自:http://www.ltesting.net