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 ? | 19 Yes | 2 No |
Post New Answer View All Answers
How is use pl and sql?
How to add a column ‘salary’ to a table employee_details?
Does truncate require commit?
Write a sql query to find the names of employees that begin with ‘a’?
Is left join faster than join?
What is the maximum number of columns in sql table?
what are all types of user defined functions? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is an implicit commit?
What is cte?
What is relationship? How many types of relationship are there?
what is a database transaction? : Sql dba
What is the use of nvl function?
Why do we need sharding?
What is the difference between nvl function, ifnull function, and isnull function?