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 is meant by tuning and tk proof?

2 Answers  


With out using count() function. How to the find total number of rows in a table?

6 Answers  


what is the command line end user interface - mysql? : Sql dba

0 Answers  


what is text? : Sql dba

0 Answers  


Is crud a cuss word?

0 Answers  






Can we insert data into view?

0 Answers  


What is the example of procedure?

0 Answers  


What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,


What makes a good primary key?

0 Answers  


How do you delete a table?

0 Answers  


what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  


What is pivot table in sql?

0 Answers  


Categories