Yes, Igor, you're correct! It is a when clause.
Rachael and Jayadas both forwarded me scripts. I'm
currently struggling with both of them, still not
getting the entire trigger.
I think Kirti's correct about setting long, since I'm
loosing pieces.
Thanks for your responses.
Barb
- Igor Neyman <ineyman_at_perceptron.com> wrote:
> Barbara,
>
> Did you mean "when" clause (not "where" clause)?
> There is "when_clause" column in
> all/dba/user_triggers.
> So, you could just add it to the script, you have.
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Monday, May 05, 2003 12:32 PM
>
>
> > Hi, all.
> > Does anyone have a script they're willing to share
> > that will capture the trigger source including a
> > "where" clause?
> >
> > I got the text below from asktom. It grabs
> everything
> > except the where. Didn't find anything in our
> > archives or google.
> >
> > TIA for any help!
> > Barb
> > Oracle 8.1.7.4
> > Solaris 2.6
> >
> > select
> > 'create or replace trigger "' ||
> > trigger_name || '"' || chr(10)||
> > decode( substr( trigger_type, 1, 1 ),
> > 'A', 'AFTER', 'B', 'BEFORE', 'I',
> 'INSTEAD
> > OF' ) ||
> > chr(10) ||
> > triggering_event || chr(10) ||
> > 'ON "' || table_owner || '"."' ||
> > table_name || '"' || chr(10) ||
> > decode( instr( trigger_type, 'EACH ROW' ), 0,
> null,
> > 'FOR EACH ROW' ) || chr(10) ,
> > trigger_body
> > from user_triggers
> > where trigger_name = upper('&1')
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Barbara Baker
> > INET: barbarabbaker_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Igor Neyman
> INET: ineyman_at_perceptron.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
INET: barbarabbaker_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon May 05 2003 - 15:32:10 CDT
