Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Expressions, 10 of 14
An object access expression specifies attribute reference and method invocation.
object_access_expression::=
The column parameter can be an object or REF
column. If you specify expr
, it must resolve to an object type.
When a type's member function is invoked in the context of a SQL statement, if the SELF
argument is null, Oracle returns null and the function is not invoked.
The following example creates a table based on the sample oe.order_item_typ
object type, and then shows how you would update and select from the object column attributes.
CREATE TABLE short_orders ( sales_rep VARCHAR2(25), item order_item_typ); UPDATE short_orders s SET sales_rep = 'Unassigned'; SELECT o.item.line_item_id, o.item.quantity FROM short_orders o;
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|