oracle 偽列__oracle

偽列：

1、分級查詢偽列(CONNECT_BY_ISCYCLE、CONNECT_BY_ISLEAF、LEVEL)

2、序列偽列(CURRVAL、NEXTVAL)

3、版本查詢偽列(VERSIONS_STARTSCN、VERSIONS_STARTTIME、VERSIONS_ENDSCN、VERSIONS_ENDTIME、VERSIONS_XID、VERSIONS_OPERATION)

4、COLUMN_VALUE

5、OBJECT_ID

6、OBJECT_VALUE

7、ORA_ROWSCN

8、ROWID

9、ROWNUM

10、XMLDATA

------------執行個體-----------------------------------------------------------------------------------------------------------------------------------------

1、CONNECT_BY_ISCYCLE、CONNECT_BY_ISLEAF、LEVEL

leve,connect_by_isleaf,connect_by_iscycle偽列

2、CURRVAL、NEXTVAL

CURRVAL、NEXTVAL

3、

4、COLUMN_VALUE

create type phone as table of number;SELECT t.COLUMN_VALUEFROM TABLE(phone(1,2,3)) t;

5、OBJECT_ID、OBJECT_VALUE

CREATE OR REPLACE TYPE person_typ AS OBJECT (  idno           NUMBER,  name           VARCHAR2(30),  phone          VARCHAR2(20))  NOT FINAL;CREATE TABLE person_obj_table OF person_typ;INSERT INTO person_obj_table  VALUES (person_typ(20, 'Bob Jones', '650-555-0130'));SELECT p.object_id, p.object_value FROM person_obj_table p;

6、ORA_ROWSCN

ORA_ROWSCN

7、ROWID、ROWNUM

ROWID、ROWNUM

8、XMLDATA