Difference between triggers and procedures?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a purchase order without a requisition?

632


What are the Standard Reports and Forms in HRMS?

1774


what is global tempory table?

6313


how do you describe O2C along with tables

2313


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1572






Do you know what is applysys in oracle application database schema, what is apps?

676


what is the difference between request group and request security in oracle apps?

5051


How is choreography different from orchestration?

654


Explain what are the tables of auto invoice?

650


Is soa a part of oracle fusion middleware?

607


In support project one ticket alloted which steps follows manualy tell me ?

2225


how to print multi lay outs,muti currency,muti language in xml publisher

10744


Can you differentiate between mediator and osb?

627


What is instead of trigger in where we will use?

680


What is oracle soa suite and what are its different components?

647