What is the syntax for creating a package specification?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

Practice Test	Free
	1Z0-147 - Oracle9i: Program with PL/SQL	Download

What is the syntax for creating a package specification?

Rating:

Following is the syntax for creating a package specification:

CREATE [OR REPLACE] PACKAGE package_name
IS | AS
public type and item declarations
subprogram specifications
END package_name;

where,

OR REPLACE option specifies that if the package specification already exists, it will be dropped and replaced with the new version created by the statement.

package_name specifies the name of the package.

public type and item declarations declare variables, constants, cursors, exceptions, or types. If a variable is not initialized with a constant value or expression within the declaration, the variable is implicitly initialized to NULL.

subprogram specifications declare the PL/SQL subprograms (functions and procedures).

All the constructs declared in a package specification are visible to users who are granted privileges on the package.

Rating:

Was this information helpful?

Click here to Article home

MCSE: MCSA, MCTS, MCITP JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation EC-212-32 CISSP Photoshop ACE Adobe Flash ACE

What is the syntax for creating a package specification?

What is the syntax for creating a package specification?

Other articles

Click here to Article home