what is the difference between trigger and storedprocedures

Answer Posted / bhanu verma

Actually triger in action which is performed automatically
before or after a event occur and stored procedure is a
procedure which is executed when the it is called.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by dbms? What are its different types?

560


Can we join more than 2 tables in sql?

500


What is cte sql?

525


How do you add a column to a table?

610


How do you explain an index?

794






What are the different types of dbmss?

573


What is a pragma statement?

732


What is a sql schema used for?

555


What is a ddl command?

547


Explain the uses of control file.

627


What is a record in a database?

567


When is a declare statement required?

679


Is drop table faster than truncate?

561


How many sectors are in a partition?

572


What is pl sql collection?

535