Re: Describing a Trigger
From: Tim <timfrith_at_nospam.home.com>
Date: Mon, 07 Feb 2000 23:21:05 GMT
Message-ID: <BrIn4.8018$_d.618639_at_news1.gvcl1.bc.home.com>
Date: Mon, 07 Feb 2000 23:21:05 GMT
Message-ID: <BrIn4.8018$_d.618639_at_news1.gvcl1.bc.home.com>
I found my answer, it was in the Oracle 8i Application Developer's Guide - Fundamentals:
To get all the trigger names:
SELECT trigger_name FROM user_triggers;
To see the code for a trigger:
SELECT trigger_body FROM user_triggers WHERE trigger_name='mytriggername';
"Tim" <timfrith_at_nospam.home.com> wrote in message
news:miGn4.7970$_d.615848_at_news1.gvcl1.bc.home.com...
> Stupid SQL Plus question:
>
> What is the command to show me the code of a trigger using SQL Plus?
>
> Tim
>
>
Received on Tue Feb 08 2000 - 00:21:05 CET