What are two parts of package ?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the sql aggregate functions?
What do you understand by case manipulation functions?
What is varchar data type in sql?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
What is the syntax to add a record to a table?
What is data manipulation language?
What is pivot query?
Write a query to get last 10 records from the table.
What is primary key and unique key?
Is pl sql a scripting language?
What is aggregate function in sql?
Can we use commit inside a trigger?