Oracle PL-SQL Question:
Download Job Interview Questions and Answers PDF
What are two parts of package?
Answer:
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.
Package Body contains actual procedures and local declaration of the procedures and cursor declarations.
Download Oracle PL-SQL Interview Questions And Answers
PDF
Previous Question | Next Question |
What is Overloading of procedures? | What is difference between a Cursor declared in a procedure and Cursor declared in a package specification? |