Oracle PL-SQL Interview Question:

What are two parts of package?

Submitted by: Administrator

The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema.
Package Body contains actual procedures and local declaration of the procedures and cursor declarations.
Submitted by: Administrator