Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Trigger DDL
Hi DBA,
Does somebody know how to modify sql statement by a DDL trigger?
Are there available such variables from which you can get a DDL statement?
What are names of these variables?
Can one modifiy them?
If you can, please write me a trigger described below.
EXAMPLE:
I type command:
create table a (id_serial number, ...);
result of running trigger BEFORE:
create table a_var01 (id_serial number, ...);
where in trigger I modified name of a table.
If you have got some examples regarding usage of DDL trigger, please sent me.
Thank you!
Rafal Received on Fri Aug 09 2002 - 03:11:59 CDT
![]() |
![]() |