what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 28603 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / roopesh kumar
Diff. B/W Procudure & Func......
(1) Proc. may or may not return value or more than one.
but func. must return a single value.
(2) We can call a func. in a select stmt. but func. should
only with IN parameter.
But we can't call a procedure inside a selct stmt.
because calling a procedure itself a PL/SQL block.
There is no too much diff. b/w proc. & func. but the thing
is that when we are looking to get back a single value we
should use func. in case of more than one then we should go
for proc.
Diff. b/w proc. & trigger..
(1) We have to call a proc. explicitly but trigger will
fire implicitly with assosiated event.
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What is rank dense_rank and partition in sql?
What type of database is sql?
What is pl sql and why it is used for?
What is tuple in sql?
how to write date and time literals? : Sql dba
How many sectors are in a partition?
What is sql partition?
Can we use views in stored procedure?
Explain character-manipulation functions?
How do I view a procedure in sql?
What is loop in pl sql?
What is union and union all keyword in sql and what are their differences?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Can we call a function containing dml statements in a select query?
Explain architecture of sql server notification services?
