Difference between triggers and procedures?

Question Posted / kiran kumar da

2 Answers
10113 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Difference between triggers and procedures?..

Answer / kiran kumar

Triggers:
--------

1)Defined with create trigger
2)The data dictionary contains source code in the user_triggers.
3)Implicitly invoked
4)Commit, save point and rollback are not allowed(TCL)

Procedures:
-----------

1)Defined with create procedure
2)Data dictionary contains source code in user_source
3)Explicitly invoked
4)Those are allowed

Note: compare both ones with numbers mentioned..

Is This Answer Correct ?

19 Yes

6 No

Difference between triggers and procedures?..

Answer / suresh.somayajula

1. Triggers are implicitly invoked but

procedures are explicitly invoked.

2. in Triggers TCL commands are not allowed.

TCL commands are allowed in Procedures.

Is This Answer Correct ?

15 Yes

4 No

Post New Answer

More Oracle Apps Technical Interview Questions

where the accounting related data is stored ?

2 Answers

What is REF Cursor?

19 Answers Infosys, Intelligroup,

q)what are the validations in sql*loader

0 Answers Accenture,

What is SRW Package? (Sql Report Writer)

1 Answers

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers TCS,

how to initialize applications?

2 Answers

do i need to declare bind parameter before using in the query?

2 Answers Satyam,

testing tools?

0 Answers BirlaSoft, Convergys,

Can you differentiate between mediator and osb?

0 Answers

what is the difference between multiorg views and multiorg tables

2 Answers Immense Source, Intelligroup, TCS,

Tell me how to find the custom directory in front end?

0 Answers

Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers TCS,

For more Oracle Apps Technical Interview Questions Click Here