| Need Help For Trigger [message #36892] |
Tue, 01 January 2002 20:05  |
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  |
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 |
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?
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
