What are two parts of package ?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the built in functions of sql?
What is procedure in pl sql?
What is basic structure of pl sql?
what are all the different normalizations? : Sql dba
What is file based approach?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is record in pl sql?
What is pl sql and why it is used for?
What is sql analyzer?
what are the different functions in sorting an array? : Sql dba
What is the difference between sql, mysql and sql server?
What is the syntax and use of the coalesce function?