Difference between triggers and procedures?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

do you know is it possible to run the interface without using oracle apps?

656


What does appl_top directory contain?

655


In sequence i want to 11 and 15th values how we will write?

1577


please send me forms, xml pulisher questions,answers

1663


What is oracle soa suite?

773






what are the different transaction clauses in AR?

1606


what is the differences between internal requisition and internal sales order?

2163


What are the Standard Reports and Forms in HRMS?

1776


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

682


What do you understand by soa and what are the benefits of using this architecture?

622


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1694


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2471


Are you familiar with internet architecture of oracle apps 11i?

638


How to create a purchase order without a requisition?

636


testing tools?

1760