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 ? | 19 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 |
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
What is sql clause?
What is rtm in testing?
How do you declare a constant?
What is dense_rank in sql?
How many joins in sql?
How do I kill a query in postgresql?
what is try_catch block in procedure
Delete the emps whose salaries are lowest sals of their own dept.
How do you use join?
what is a composite primary key ? : Sql dba
What is materialised View?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)