oracle trigger (how to move forward)
I have an oracle trigger that works fine when you manually run it. How can I take the following trigger and make it repeat instead of specifically copying it for each table. For instance..
I have to run this several times for each different 'company'.
accept compnum prompt 'Enter Company Number: '
define logging = "_logging" (CHAR)
create or replace trigger ttfacp100&compnum&logging
before insert on ttfacp100&compnum
for each row
declare
logname varchar2(8);
begin
select user into logname from dual;
:new.t$logn := logname;
end;
/
----------------------------------------------------------------
I want to be able to have a list of companies that run the trigger each time it changes, but only call this script once.
Can something like this be done?
define logging = "_logging" (CHAR)
define compnum = 100
run.trigger()
define compnum = 200
run.trigger()
define compnum = 300
run.trigger()
run.trigger()
{
create or replace trigger ttfacp100&compnum&logging
before insert on ttfacp100&compnum
for each row
declare
logname varchar2(8);
begin
select user into logname from dual;
:new.t$logn := logname;
end;
/
}
Thank you!
-Tim
|