Packages

Question 1

What are packages?

Answer 1

Schema objects that groups logically related PL/SQL types, variables, and subprograms

Question 2

What are the two components of a package?

Answer 2

• Package specification

- Package body or definition

Question 3

What does the package specification do?

Answer 3

DECLARES the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package

Question 4

All objects placed in the specification are called ____

Answer 4

Public objects

Question 5

Any subprogram not in the package specification but coded in the package body are called ___

Answer 5

Private objects

Question 6

What is the syntax for the package specification?

Answer 6

CREATE OR REPLACE PACKAGE name IS
–Declaration of global variables, types, cursors
–Headers of public procedures & functions public (implicit)
END name;

Question 7

What is the package body?

Answer 7

Has the codes for various methods declared in the package specification and other private declarations

Question 8

What is the syntax for the package body?

Answer 8

CREATE OR REPLACE PACKAGE BODY name IS
#Declare private variables, types, cursors
#Code public and private functions and procedures
END name;

Question 9

Where is package code loaded on first call?

Answer 9

Memory

Question 10

What permissions does the package have run you run the code?

Answer 10

The same of the owner of the package

Question 11

Can you compile the specification and body separately?

Answer 11

Yes

Question 12

What is the syntax for accessing package elements?

Answer 12

package_name.element_name;