Answers were Sorted based on User's Feedback
Answer / tulsi
The two parts of package are PACKAGE SPECIFICATION &
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 ?||16 Yes||2 No|
Answer / senthil kumars
Package Contains Two Parts.They Are
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 ?||11 Yes||1 No|
What port does sql server use?
What is audit logout in sql profiler?
How to come back in normal stage in Mutating Table if mutating table is locked or update data?
How many commands are there in sql?
How to test for null values?
How do you take the union of two tables in sql?
what is 'mysqlimport'? : Sql dba
Explain dml and ddl?
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
what is oracle database ? : Sql dba
Can dml statements be used in pl/sql?
What is ROWID?