4. what is the difference between stored procedures and stored functions in ORACLE

what is the difference between stored procedures and stored functions in ORACLE

Answer

Both(functions and Procedures) are the Oracle Objects that work explicitly towards database objects like Tables,Views.

The diff. b/t Stored Procedures and Functions

1) The procedures doesn't return values. whereas the function returns value.

2) The procedures accept more than one argument whereas the functions not.

All stored-procedures Questions
Ask your interview questions on stored-procedures

Write Your comment or Questions if you want the answers on stored-procedures from stored-procedures Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---