Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26658 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 are the uses of linked server and explain it in detail?
What are the different types of database objects?
How to resolve name conflicts between variables and columns?
How to convert times to characters in oracle?
How to assign query results to variables?
Define oracle database
Can we store pictures in the database and if so, how it can be done?
how to handle exceptions in post production
What is the difference between alert log file and tarce file ?
what is difference between sql plus and sql*plus? (not sql and sql plus).
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to use null as conditions in oracle?
How to run queries on external tables?
Explain the use of grant option in exp command.
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
