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

Ask an Expert

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

Write your message here..

Related Questions

Theory of panspermia - origin of life, THEO R Y OF PANSPERMIA - Arrh... 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, JOIN and AND in SQL In this Section is all about ... 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, Develop Data Business Intellige... 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, PITS Depressions in secondary cell wall is called pit. A pi... 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 - SQL Ex... 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 - sql, Example of Cast Operator So long as C... 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 - functions, Parameter & Keyword Descriptio... Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Difference between implicit and explicit cursor, Implicit Cursor is declare... 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

Calculate the number of tuples, Question: (a) The objective of query opti... 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, Subprograms The PL/SQL has two types of subprograms known ... 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