Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26377 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
How to create lov dynamically at runtime & attach to text field?
How to return top 5 rows in oracle?
What is an oracle wallet?
what is the difference between restoring and recovering?
What happens to the current transaction if a ddl statement is executed?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is oracle host variable?
Point out the difference between user tables and data dictionary?
How to create a testing table in oracle?
Explain what are clusters?
query optmization techniques and quwry analyser+projects+ppts
How to retrieve the count of updated rows?
Is oracle the best database?
What is oracle latest version?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
