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
1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Renaming Columns - SQL SQL has no direct counterpart of RENAME. To derive the table on the right in Figure 4.4 from the table on the left, Tutorial D has IS_CALLED RENAME ( St

Fetching from a Cursor Variable The FETCH statement retrieve rows one at a time from the product set of a multi-row query. The syntax for the same is as shown: FETCH {curso

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Avoiding Collection Exceptions   In many cases, if you reference a nonexistent collection element, then PL/SQL raises a predefined exception. Consider the illustration shown b

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ

Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG