Trigger will fire when the condition arises but the stored procedure will

what is the difference between trigger and storedprocedures

Question Posted / anbu

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

Please Help Members By Posting Answers For Below Questions

What is rowtype?

1027

What are the different types of constraints?

1192

explain the delete statements in sql

1065

How can I tell if sql is running?

1070

How is debugging done?

986

Explain how exception handling is done in advance pl/sql?

1001

What is the order of sql select?

1043

what are myisam tables? : Sql dba

1037

how is myisam table stored? : Sql dba

1061

What is a recursive join sql?

1077

Why is there a need for sqlcode and sqlerrm variables?

1054

What is delete command in sql?

1120

What do you think about pl/sql?

1041

What is pl sql collection?

978

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1046