What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 25168 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / s. elaiyaraja
The Main difference between stored procedure and Function
is SP's can return the value or not, but Functions should
return the value.
And We can use the function within the Queries, but sp's we
won't able to use it in the queries.
We can implicitely execute the sp's. But function's we
can't.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is a cursor variable?
Explain an integrity constrains?
How can I create database in oracle?
How to convert characters to dates in oracle?
What is object data modeling?
what is the dual table in oracle?
What is a snapshot log?
Explain the use of analyse option in exp command.
What is hot backup and logical backup?
How to loop through data rows in the implicit cursor?
Query to retrieve record for a many to many relationship ?
How much memory your 10g xe server is using?
How to create a server parameter file?
What is max rowid in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
