Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 163 of 177
value::=
VALUE
takes as its argument a correlation variable (table alias) associated with a row of an object table and returns object instances stored in the object table. The type of the object instances is the same type as the object table.
The following example uses the sample table oe.persons
, which is created in
"Substitutable Table and Column Examples": SELECT VALUE(p) FROM
persons p;
VALUE(P)(NAME, SSN)
-------------------------------------------------------------
PERSON_T('Bob', 1234)
EMPLOYEE_T('Joe', 32456, 12, 100000)
PART_TIME_EMP_T('Tim', 5678, 13, 1000, 20)
See Also:
"IS OF type Conditions" for information on using |
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|