top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

+1 vote
1,138 views
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
posted Nov 11, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Stored Procedures and Functions
A procedure or function is a schema object that logically groups a set of SQL and other PL/SQL programming language statements together to perform a specific task. Procedures and functions are created in a user's schema and stored in a database for continued use. You can execute a procedure or function interactively using an Oracle tool, such as SQL*Plus, or call it explicitly in the code of a database application, such as an Oracle Forms or Precompiled application, or in the code of another procedure or trigger.
Packages
A package is a group of related procedures and functions, together with the cursors and variables they use, stored together in the database for continued use as a unit. Similar to standalone procedures and functions, packaged procedures and functions can be called explicitly by applications or users.

answer Nov 13, 2014 by Manikandan J
...