Packages

The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the body.

Syntax:

Posted Date: 10/8/2012 7:26:08 AM | Location : United States

Ask an Expert

Related Discussions:- Packages, Assignment Help, Ask Question on Packages, Get Answer, Expert's Help, Packages Discussions

Write discussion on Packages
Your posts are moderated

Write your message here..

Related Questions

Keyword, what is the use of declare keyword what is the use of declare keyword

Transactions in sql, Transactions in SQL BEGIN TRANSACTION, COMMIT, an... Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Rollback behavior - bulk bind performance improvement, Rollback Behavior ... Rollback Behavior When a FORALL statement fails, the database changes are rolled back to an implicit savepoint marked before each of the SQL statement execution. The Changes t

Using host arrays - bulk bind performance improvement, Using Host Arrays ... Using Host Arrays The Client-side programs can use anonymous PL/SQL blocks to bulk-bind input and output host arrays. However, this is the well-organized way to pass the colle

Sql, If two relations R and S are joined, then the non matching tuples of b... If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Relational algebra, Define basic operators of relational algebra with an ex... Define basic operators of relational algebra with an example each

Quantification in sql, Quantification in SQL To quantify something, as... Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Cursors - syntax, Cursors   To execute the multi-row query, the Oracle... Cursors   To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the informa

Exception_init pragma - pl/sql, EXCEPTION_INIT Pragma The pragma EXCEPT... EXCEPTION_INIT Pragma The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to wri

Assignment statement in pl sql, Assignment Statement: The assignment s... Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by