How to get code of trigger? 1

[lakshmivaragan]

Hi,
I understand that triggers available can be extracted from the all_objects table. Is there any way to get the code of particular trigger? I mean, Does Oracle stores the code of triggers somewhere to extract?

Regs
Lax

 

[SantaMufasa]

Lax,

set linesize 200
set long 1000000
select trigger_body from user_triggers where trigger_name = 'UPPER-CASE NAME OF TRIGGER HERE';

You can get similar results from DBA_TRIGGERS and ALL_TRIGGERS, as well.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:05 (31Dec03) GMT, 23:05 (30Dec03) Mountain Time)

 

[sbix]

Muf,
you're unchained today