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
Semidifference via EXCEPT and JOIN - SQL SELECT * FROM (SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' EXCEPT DISTINCT CORRESPONDING SELECT StudentId

Recursive Subprograms The recursive subprogram is the one that calls itself. Think of a recursive call as a call to a few other subprograms that does the similar task as your

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

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