Interested to Buy Any Domain ? << Click Here >> for more details...
What are two parts of package ?
- 2 Answers
- 17429 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
What is a schema sql?
How do I debug a stored procedure?
What is a join query?
What is the difference between having and a where in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
How does stored procedure reduce network traffic?
Types of cursor locks and explanation each of them ?
difference between cursor and procedure in a package
Why left join is used in sql?
What are the popular database management systems in the it industry?
What is the clause we need to add in function body to return variable?
select 10 from dual; y its showing all the rows with 10?
-
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)
