what is the difference between trigger and storedprocedures
Answers were Sorted based on User's Feedback
triggers are invoked implicitly , while storedprocedures
are invoked explicitly.
Is This Answer Correct ? | 18 Yes | 1 No |
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.
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / 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 |
Answer / tina
Hello Sharma,
Stored procesure is also have compiled code like triggers.
Thanks,
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / surajit pathak
Another One Important difference is you can Enable or
Disable the Trigger. which you can not do ..
Is This Answer Correct ? | 7 Yes | 0 No |
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.
Is This Answer Correct ? | 5 Yes | 0 No |
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,
Is This Answer Correct ? | 3 Yes | 0 No |
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....
Is This Answer Correct ? | 3 Yes | 1 No |
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.
Is This Answer Correct ? | 3 Yes | 2 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
What is sql injection vulnerability?
How to display all Friday's in a year with date?
define sql insert statement ? : Sql dba
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
Delete the emps whose salaries are lowest sals of their own dept.
Define sql delete statement.
How does cross join work in sql?
What is blind sql injection?
What is sql performance tuning?
Why do we use view in sql?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
how will i became good database developer?