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.

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

0 Answers  

How many sql are there?

0 Answers  

Why do we use joins in sql?

0 Answers  

Is oracle and sql same?

0 Answers  

how to rename an existing table in mysql? : Sql dba

0 Answers  

how to shutdown mysql server? : Sql dba

0 Answers  

what are different types of collation sensitivity? : Sql dba

0 Answers  

What is the unique index?

0 Answers  

How do you bind variables in pl sql?

0 Answers  

how can we destroy the cookie? : Sql dba

0 Answers  

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,