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

0 Answers  


what is the command for user data type?

2 Answers  


why not null constraint showing its constraint type as 'c'

1 Answers  


How to run sql*plus commands in sql developer?

0 Answers  


how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  






What is a natural join sql?

0 Answers  


Which query operators in sql is used for pattern matching?

0 Answers  


What is materialized view. What are different methods of refresh?

0 Answers  


Differentiate between syntax and runtime errors.

0 Answers  


How many functions are there in sql?

0 Answers  


What is null in pl/sql?

0 Answers  


Why indexing is needed?

0 Answers  


Categories