Declaring and initializing objects in pl/sql, PL-SQL Programming

Declaring and Initializing Objects:

An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or package. For illustration, you can use the object type to specify the datatype of a column, attribute, variable, bind variable, table element, record field, formal parameter, or function result. At the run time, instances of the object type are formed that is, the objects of that type are instantiated. Each object can hold various values. These objects follow the usual scope and instantiation rules. In a subprogram or block, the local objects are instantiated whenever you enter the block or subprogram and cease to exist when you exit. In a package, the objects are instantiated when you first reference the package and cease to exist whenever you end the database session.

 

Posted Date: 10/6/2012 8:10:42 AM | Location : United States







Related Discussions:- Declaring and initializing objects in pl/sql, Assignment Help, Ask Question on Declaring and initializing objects in pl/sql, Get Answer, Expert's Help, Declaring and initializing objects in pl/sql Discussions

Write discussion on Declaring and initializing objects in pl/sql
Your posts are moderated
Related Questions
THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

Develop Data Business Intelligence Project Project Description: We are linking our Microsoft SQL Database to GoodData Business Intelligence. We are seeking somebody who has e

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp