what is the difference between trigger and storedprocedures

Answer Posted / monika nargotra

triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain alias in sql?

772


What is trigger in sql? Explain

702


What is an implicit commit?

762


How do you update a value in sql?

717


What is pl sql code?

752






what are dynamic queries in t-sql? : Transact sql

747


What is procedure explain with program?

724


What is sql character function?

715


what are the differences between binary and varbinary? : Sql dba

724


What are the advantages of indexing?

731


What is aggregate function in sql?

738


What are % type and % rowtype?

780


What does select count (*) mean in sql?

742


What is the use of function "module procedure" in pl/sql?

889


explain the difference between myisam static and myisam dynamic. : Sql dba

708