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 are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1117

How to Execute a Package in PL/SQL.?

1278

Which one is better subquery or joins?

1114

What is Difference Between Unique and Primary Key Constraints?

1151

Can a table contain multiple foreign key’s?

1047

What does rownum mean in sql?

1088

How do I pipe the output of one isql to another?

1054

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

1083

What are different clauses used in sql?

1170

what is the difference between clustered and non clustered index in sql? : Sql dba

1182

Do we need to rebuild index after truncate?

1094

Is left join faster than inner join?

1166

Define tables and fields in a database

1175

What does the file extension accdb stand for?

1012

Can we create table inside stored procedure?

1009