Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trigger DDL

Trigger DDL

From: Rafal Hejnowicz <rhejnowicz_at_telmax.com.pl>
Date: Fri, 9 Aug 2002 10:13:02 +0200
Message-ID: <aivtg7$rhu$1@news2.tpi.pl>


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:13:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US