Answer / bhanu verma

Actually triger in action which is performed automatically
before or after a event occur and stored procedure is a
procedure which is executed when the it is called.

Answer / monika nargotra

triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.

Answer / srikanth

Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.

triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.

Answer / nandkumar

There are bascis 3 difference between them
1> trigger invokes implicitly while we need to invoke
procedure explicitly.
2> We cant pass values from user to trigger but we can pass
values into procedure.
3> Trigger cant return value procedure can return value.

Answer / sharma.dharmpal

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

Answer / sam katwal

Both are Same
Triggers are special Stored Producedures which are created
by User whereas Stored Procedures are created by the System.

How do you go back in sql?

0 Answers  

Can ddl statements be used in pl/sql?

0 Answers  

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

Does db2 use sql?

0 Answers  

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

How can I change database name in sql?

0 Answers  

Explain the structure of pl/sql in brief.

0 Answers  

What is using in sql?

0 Answers  

What is the difference between alter trigger and drop trigger statements?

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

what tools available for managing mysql server? : Sql dba

0 Answers