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
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

ROWID and UROWID Internally, every database table has a ROWID pseudo column that stores binary values known as rowids. Each rowid shows the storage address of a row. A physical

Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla

Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

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

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th

Varrays versus Nested Tables The Nested tables are differing from varrays in the following ways: 1)  Varrays have a maximum size, while nested tables do not. 2)  Varrays are

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su