Syntax to know all tha list of triggers:
select * from user_triggers;
Syntax to see list of triggers on specific table:
select trigger,trigger_type,status,description,trigger_body from user_triggers where table_name='emp';
Syntax to see all the list of sub programs:
select * from user_source;
Syntax to see the source code of the program:
select text from user_source where name='name_of_program';
Example:select text from user_source where name='FUN';
select * from user_triggers;
Syntax to see list of triggers on specific table:
select trigger,trigger_type,status,description,trigger_body from user_triggers where table_name='emp';
Syntax to see all the list of sub programs:
select * from user_source;
Syntax to see the source code of the program:
select text from user_source where name='name_of_program';
Example:select text from user_source where name='FUN';
No comments:
Post a Comment
If you Like my blog Spread it and help friends for whom this blog is useful for their career.