Thursday, 25 February 2016

SYNTAXES

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';

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.