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
- 25421 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
Does pl sql work in mysql?
Can we use view in stored procedure?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
difference between anonymous blocks and sub-programs.
how to load data files into tables with 'mysqlimport'? : Sql dba
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What are the sql commands?
what is the difference between union and union all? : Sql dba
What is a table?
Is sql port 1433 encrypted?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Can unique keys be null?
What is left join in sql?
What are pl sql data types?
What is trigger and how to use it in sql?
