34 of 38
Usage #5:
Example
Create
or replace trigger u_uml_attrib
Instead of Insert on
uml_attrib
For each row
Declare
pragma autonomous_transaction;
Begin
if check(:new.attrib_cd)=‘Y’
then
execute immediate
‘ alter table ’||:new.class_cd
||‘ add column ’||:new.attrib_cd
||‘ ’||:new.datatype;
commit;
End;