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 rename in sql?

919

Explain isolation levels. : Transact sql

1017

what is difference between delete and truncate commands? : Sql dba

1067

What is the difference between having clause and where clause?

1011

what is datawarehouse? : Sql dba

956

how can you create an empty table from an existing table? : Sql dba

1080

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

945

what is cursor. write example of it. What are the attributes of cursor.

1312

Show the cursor attributes of pl/sql.

998

what is sp_pkeys? : Transact sql

1105

Can you load data into multiple tables at once? : aql loader

1024

What is the difference between inner join and natural join?

956

How to display the records between two range in Oracle SQL Plus?

1101

Is pl sql a scripting language?

971

What does partition by mean in sql?

910