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語句,答案正確馬上結貼
- Oracle集群问题
- 一个SQL 的问题
- 奇怪得问题,关于trim ,replace
- 为什么出现‘NEW或OLD引用不允许在表层触发器中’的编译错误
- 巨简单的问题
- 谁能详细解释一下锁是怎么产生的以及如何解锁?100分相送。
- 郁闷!那位有在win2000专业版下,安装oracle9i的成功经历???
- 我的shared_pool_size 都已经设成90M了,怎么还出ORA-04031错误?
- 子程序或游标 'TEST2' 已在程序包说明中声明, 必须在程序定义 怎么回事 看视频能完美运行 我的代码就抱着错误
- ocisessionbegin:error while trying to retrieve text for error ora-24327
- 请问在delphi调用PL/SQL的时候,如果参数是数组的话,应该如何传递 急
VALUE是利用了同意词。