what is the difference between trigger and storedprocedures

Answer Posted / anbu

Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I get sql certification?

518


What is rtm in testing?

567


What is oracle sql called?

499


What is a relationship and what are they?

572


What is data types in sql?

528






What is before and after trigger?

514


What is the difference between the conventional and direct path loader? : aql loader

642


How can we optimize a sql query?

569


What is hibernate and its relation to sql?

587


Can we use view in stored procedure?

495


Explain exception handling in pl/sql?

523


What are the triggers associated with image items?

612


Why is sql*loader direct path so fast?

593


What is join view in sql?

504


List and explain the different types of join clauses supported in ansi-standard sql?

804