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

what is self-join? : Sql dba

756


List the various privileges that a user can grant to another user?

774


What does over partition by mean in sql?

709


What is raw datatype in sql?

725


How many types of tables are there?

692






Define overloaded procedure?

803


Is natural join and inner join same?

654


What is basic structure of pl sql?

686


Can we join 3 tables in sql?

705


What is the difference between pl and sql?

737


Explain cursor types?

750


What does an inner join do?

781


What are schema-level triggers?

757


explain what is mysql? : Sql dba

787


How you improve the performance of sql*loader? : aql loader

752