What is the difference between function, procedure and package in PL/SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    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.

Related Questions

Please Login or Register to leave a response.

Related 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 ..