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
Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'

Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )

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

Anatomy of a Command Figure, showing a simple SQL command, is almost identical to its counterpart in the theory book. The only difference arises from the fact that SQL uses a

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Using COMMIT The COMMIT statements end the present transaction and make permanent any changes made during that transaction. Till you commit the changes, other users cannot acc

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

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Using the student and faculty tables create a select query that outputs all students for a specific advisor. Generate the execution plan, select out the explain plan . Create an

Using Subqueries A subquery is a query (typically enclosed by parentheses) that appears within another SQL data manipulation statement. If evaluated, the subquery gives a va