Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
- 4 Answers
- 25358 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / sohail
1.Procedure is a subrotine which completly utilises the
concept of stack.
2.Procedure can be called any time when required where as
trigger once created we cannot stop the trigger to fire
when not required.
3.triggers are fired implicitly where as procedure are
called explicitly by procedure name when required.
4.the p_code of procedure is stored in oracle SGA and can
be global to others.
| Is This Answer Correct ? | 14 Yes | 11 No |
Post New Answer View All Answers
Which join is like inner join?
What is cte sql?
What are the parts of a basic sql query?
what is a database transaction? : Sql dba
What is the difference between drop and truncate commands?
Explain some predefined exceptions.
What steps server process has to take to execute an update statement?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is dba in sql? : SQL DBA
How to use sql statements in pl/sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
How do you update sql?
What is sql comments?
how to start mysql server? : Sql dba
What is asqueryable?
