What are two parts of package ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is bcp? When is it used?

582


How do I install sql?

524


How can I delete duplicate rows?

564


What found sql?

528


What is java sql connection?

514






What company owns postgresql?

562


Can we group by two columns in sql?

507


What is sql injection vulnerability?

494


Define overloaded procedure?

622


How do sql triggers work?

552


Which version of sql do I have?

564


What is pl sql script?

564


What packages(if any) has oracle provided for use by developers?

5034


What are different types of functions in sql?

511


Can you inner join the same table?

527