Re: Trigger DDL

Rafal Hejnowicz wrote:

> 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

This can not be done.

Nor should it be.

DDL should not be performed by trained or semi-trained monkeys. Write the DDL correctly and only have a DBA implement it.

Daniel Morgan Received on Sun Aug 11 2002 - 09:11:36 CDT