What is the difference between function, procedure and package in PL/SQL?
devquora
Posted On: Feb 22, 2018
-
Answered by devquora
the main difference between a function and a procedure in PL/SQL is that a function returns a value, while a procedure does not. A package is a collection of related program units that provides a way to organize and encapsulate program logic.
1 Answer Written
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
PL/SQL Interview Questions
What is PL/SQL?
PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..
PL/SQL Interview Questions
Differentiate between PL/SQL and SQL?
PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..
PL/SQL Interview Questions
State few characteristics of PL/SQL?
Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..