What is the difference between triggers and procedures?

Answer Posted / sangeeta

Triggers are group of SQL statements which are executed
automatically in response to the DML ie. Data Manipulation
Language - insert / update / delete.

Procedures are also group of SQL statements submitted
together to the server for execution. Unlike triggers
Procedures have to be executed explicitly.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the steps in writing a java program using jdbc?

454


What are the 4 types of jdbc drivers?

515


What is the meaning of batch updates?

566


How do I know which jdbc driver to use?

601


Explain the life cycle of jdbc.

647






Explain the various types of locking system in jdbc?

499


What is xe in oracle jdbc url?

546


Is jdbc part of j2ee?

514


Which is better odbc or jdbc?

507


How data can be inserted into long row column of database?

1708


How to move the cursor in scrollable resultset ?

577


What are the differences between execute, executequery, and executeupdate?

491


What is the difference between jdbc and odbc?

530


How MS-Access DB can be accessed over a network, using JDBC API?

2022


Explain the difference between rowset vs. Resultset in jdbc?

579