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 sql aggregate functions?

0 Answers  


What do you understand by case manipulation functions?

0 Answers  


What is varchar data type in sql?

0 Answers  


What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,


What is the syntax to add a record to a table?

0 Answers  






What is data manipulation language?

0 Answers  


What is pivot query?

0 Answers  


Write a query to get last 10 records from the table.

12 Answers   iNautix,


What is primary key and unique key?

0 Answers  


Is pl sql a scripting language?

0 Answers  


What is aggregate function in sql?

0 Answers  


Can we use commit inside a trigger?

0 Answers  


Categories