What are two parts of package ?

Answers were Sorted based on User's Feedback



What are two parts of package ?..

Answer / tulsi

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

Is This Answer Correct ?    18 Yes 2 No

What are two parts of package ?..

Answer / senthil kumars

Package Contains Two Parts.They Are

*Package Spec
*Package Body

Package Spec contains declarations of procedures,functions
Where as Package Body Contains definitions for the
procedures and functions which r declared in the spec. Also
it contains the local variables which r to be used in the
procedure or function

Is This Answer Correct ?    12 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What are the built in functions of sql?

0 Answers  


What is procedure in pl sql?

0 Answers  


What is basic structure of pl sql?

0 Answers  


what are all the different normalizations? : Sql dba

0 Answers  


What is file based approach?

0 Answers  






Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  


What is record in pl sql?

0 Answers  


What is pl sql and why it is used for?

0 Answers  


What is sql analyzer?

0 Answers  


what are the different functions in sorting an array? : Sql dba

0 Answers  


What is the difference between sql, mysql and sql server?

0 Answers  


What is the syntax and use of the coalesce function?

0 Answers  


Categories