Components of an object type in pl/sql, PL-SQL Programming

Components of an Object Type:

An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but not exceptions, constants, cursors, or types. You should declare at least one attribute (the highest is 1000); methods are optional. You cannot add the attributes to an existing object type (i.e., the type evolution is not supported).

 

 

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







Related Discussions:- Components of an object type in pl/sql, Assignment Help, Ask Question on Components of an object type in pl/sql, Get Answer, Expert's Help, Components of an object type in pl/sql Discussions

Write discussion on Components of an object type in pl/sql
Your posts are moderated
Related Questions
Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump i

On occasion, some of Brewbean's customers mistakenly leave an item out of a basket already checked out, so they create a new basket containing the missing items. However, they requ

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Parameter and Keyword Description: record_type_name: This identifies the user-defined type specifier that is used in the subsequent declarations of the records. NOT N