Home » SQL & PL/SQL » SQL & PL/SQL » Need Help For Trigger
Need Help For Trigger [message #36892] Tue, 01 January 2002 20:05 Go to next message
Sandipta N Biswas
Messages: 7
Registered: December 2001
Junior Member
Hi every body, happy prosperus new year to you all.

I have created a trigger name 'AUDIT_Trail'. it executed properly. now I want to see the trigger_type, table_name, triggering_event corresponding to the trigger 'AUDIT_TRAIL'. Is it being stored in Data Dictionary view 'user_trigger'? how I will see the view? I am using SQL plus 3.3 and login/password is default. that is 'scott' and 'tiger'.
advance thanks for help me.

----------------------------------------------------------------------
Re: Need Help For Trigger [message #36894 is a reply to message #36892] Tue, 01 January 2002 23:24 Go to previous messageGo to next message
Somu
Messages: 24
Registered: February 2000
Junior Member
Hi,

Wish you a very Happy New Year,

You can use ALL_TRIGGERS table for the above details.

----------------------------------------------------------------------
Re: Need Help For Trigger [message #36896 is a reply to message #36894] Tue, 01 January 2002 23:34 Go to previous message
Sandipta N Biswas
Messages: 7
Registered: December 2001
Junior Member
Thank u Somu for help. I typed "select * from all_triggers;" but the sql prompt showing the message "buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA". What to do. Please guide.
N.B: I used the select command from scott/tiger login/password. am I correct?

----------------------------------------------------------------------
Previous Topic: LONG RAW Limitation
Next Topic: Default value in Array
Goto Forum:
  


Current Time: Tue Aug 11 14:44:41 CDT 2020