One more difference is that Trigger is compiled code where as stroed proc

what is the difference between trigger and storedprocedures

Question Posted / sharma.dharmpal

Answer Posted / sharma.dharmpal

One more difference is that Trigger is compiled code where
as stroed procedure is not.

Is This Answer Correct ?

4 Yes

16 No

Please Help Members By Posting Answers For Below Questions

How to select unique records from a table?

1013

Is pl sql useful?

941

how do you know the version of your mysql server? : Sql dba

955

how can we find the number of rows in a table using mysql? : Sql dba

1045

Does postgresql run on the cloud?

1089

What is primary key sql?

965

how mysql optimizes distinct? : Sql dba

1018

What are schema-level triggers?

1057

What is bind variable in pl sql?

995

Can we use threading in pl/sql?

985

Can you sum a count in sql?

963

What are all ddl commands?

1028

How does postgresql compare to "nosql"?

995

Why are aggregate functions called so?

908

What is %s in sql?

982