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_VALUE
FROM 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