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.

define sql

3 Answers   Zensar,

Why triggers are used?

0 Answers  

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

What is the difference between partition and index?

0 Answers  

What are the three pl sql block types?

0 Answers  

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

Why is theta join required?

0 Answers  

Does truncate release storage space?

0 Answers  

Can we create table in function?

0 Answers  

what are the advantages a stored procedure? : Sql dba

0 Answers  

How to call the function and Procedure in trigger?

3 Answers   IBM,

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,