Answer / narendra duby

triggers are invoked implicitly , while storedprocedures
are invoked explicitly.

Answer / sohail

Trigger and procedures are same but the substantial
difference is when they run.procedure is invoked explicitly
by the user and trigger is executed implicitly. another
diffrence is procedure cannot have the same name as table
name,funtion name or package name but trigger can have same
name as table name or procedure name.

Answer / anbu

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

Answer / tina

Hello Sharma,

Stored procesure is also have compiled code like triggers.

Thanks,

Answer / surajit pathak

Another One Important difference is you can Enable or
Disable the Trigger. which you can not do ..

Answer / poonam

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. Stored
procedure is module.

Answer / satish kumar

stored procedure are collections of T-sql statements and
they are pre complied staements,it not requiers any
complitation.

trigger are not pre complied statements , and they are
going to activate only when certain action takes place like
insert , update, delete,

Answer / nancy

BASIC DIFFERENCE IS trigger is automatically executed without an action required by a user where as stored procedure needs to be explicitly invoked...

a database TRIGGER ia a STORED PROCEDURE that is fired when an insert,update or deletestatements is issued against the associate table.a trigger is fired whwn database related event occurs....

Answer / nagapawan

i want tell u that in 1)oracle- sql & pl/sql
2) sql server - sql & T-sql

all r giving the same answers to both , some difference
r there. for example writing a code different in oracle and
sql
server. in oracle- sql & pl/sql we can write big statements
and in sql server - sql & T-sql small statements ie,code.
ok . keep rememeber while answering it, wheather it is
oracle r sql server we r answering.
i have knowledge in both - oracle & sql server.

Answer / sunny kumar rana

1) A stored procedure can accept parameters while a trigger
cannot.
2) A trigger can’t return any value while stored procedures
depand on condition.
3) A trigger is executed automatically on some event while
a stored procedure needs to be explicitly called.
4) Triggers are used for insertions, update and deletions
on tables while stored procedures are often using
independently in the database.
5) A trigger cannot be written in a stored procedure.
However, the reverse is not possible.

Does oracle use sql?

0 Answers  

What is the default value of CHAR type?

3 Answers   Bosch,

How do you use a while loop in pl sql?

0 Answers  

What is trigger in flip flop?

0 Answers  

What is pragma exception and how, when, where us

5 Answers  

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

How do I run a pl sql procedure in sql developer?

0 Answers  

What does the file extension accdb stand for?

0 Answers  

How do you write a subquery?

0 Answers  

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

What is the purpose of primary key?

0 Answers  

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers