Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL for triggers.
Maxim Demenko wrote:
> joel garry schrieb:
>
> I don't have 9i actually to test, but i doubt, it would behave
> differently. Here is for 10gR2
>
> SQL> select * from v$version
> 2 /
>
> BANNER
> --------------------------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
> PL/SQL Release 10.2.0.2.0 - Production
> CORE 10.2.0.2.0 Production
> TNS for Linux: Version 10.2.0.2.0 - Production
> NLSRTL Version 10.2.0.2.0 - Production
>
> SQL> set long 1000000 pages 0
> SQL> select dbms_metadata.get_ddl('TRIGGER','FILES_TRG') from dual;
>
Thank you Maxim, that is indeed what I was missing.
D'Oh!
jg
-- @home.com is bogus. http://www.dumbthings.comReceived on Thu Oct 26 2006 - 17:14:27 CDT