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

Home -> Community -> Usenet -> c.d.o.server -> Re: DDL for triggers.

Re: DDL for triggers.

From: joel garry <joel-garry_at_home.com>
Date: 26 Oct 2006 15:14:27 -0700
Message-ID: <1161900867.368650.259950@h48g2000cwc.googlegroups.com>

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.com
Received on Thu Oct 26 2006 - 17:14:27 CDT

Original text of this message

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