Syntax
Purpose
In a SQL statement, 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.
Example
CREATE TYPE emp_type AS OBJECT
(eno NUMBER, ename VARCHAR2(20), salary NUMBER);
CREATE TABLE emp_table OF emp_type
(primary key (eno, ename));
INSERT INTO emp_table VALUES (10, 'jack', 50000);
SELECT VALUE(e) FROM emp_table e;VALUE(E)(ENO, ENAME, SALARY)
----------------------------------------------------
EMP_TYPE(10, 'jack', 50000)
Purpose
In a SQL statement, 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.
Example
CREATE TYPE emp_type AS OBJECT
(eno NUMBER, ename VARCHAR2(20), salary NUMBER);
CREATE TABLE emp_table OF emp_type
(primary key (eno, ename));
INSERT INTO emp_table VALUES (10, 'jack', 50000);
SELECT VALUE(e) FROM emp_table e;VALUE(E)(ENO, ENAME, SALARY)
----------------------------------------------------
EMP_TYPE(10, 'jack', 50000)
解决方案 »
- oracle导出表问题
- order by
- 机器上已经安装SQL Sever2005,请问在机器上再安装Oracle9i或Oracle10会不会有冲突?
- 请问各位大侠,触发器要在触发后查询本表,有什么办法么?
- 启动时要自动挂一个回滚段,但段名称是小写的,该怎么办?
- 急问运行在oraclek中的一条SQL语句,大家帮忙呀!!!
- 新手问题!
- 请帮我看看这个blob问题[jsp处理blob]
- local PC运行没有问题,但是在application上运行出错
- oracle高并发写操作的优化
- ocisessionbegin:error while trying to retrieve text for error ora-24327
- 请问在delphi调用PL/SQL的时候,如果参数是数组的话,应该如何传递 急
VALUE是利用了同意词。