I'm working with Oracle table containing column of XMLType. I found that it is virtual but when I was creating the table the column was not marked with "virtual" property. So my question is why this column is virtual in ALL_TAB_COLS and is it really virtual or not? Create table statement:
CREATE TABLE ALL_TYPES
(
MAXVARCHAR2 VARCHAR2(4000),
MINVARCHAR2 VARCHAR2(1),
MAXVARCHAR VARCHAR2(4000),
MINVARCHAR VARCHAR2(1),
MAXCHAR CHAR(2000),
MINCHAR CHAR,
MAXNCHAR NCHAR(1000),
MINNCHAR NCHAR(1),
MAXNUMBER NUMBER(*, 127),
NORMALNUMBER NUMBER,
MINNUMBER NUMBER(1, -83),
BINARYFLOAT BINARY_FLOAT,
BINARYDOUBLE BINARY_FLOAT,
LONG_ LONG,
DATE_ DATE,
MINTIMESTAMP TIMESTAMP(0),
TIMESTAMP TIMESTAMP(6),
MAXTIMESTAMP TIMESTAMP(9),
MINTIMESTAMP_TZ TIMESTAMP(0) WITH TIME ZONE,
TIMESTAMP_TZ TIMESTAMP(6) WITH TIME ZONE,
MAXTIMESTAMP_TZ TIMESTAMP(9) WITH TIME ZONE,
MINITERVAL_YEAR INTERVAL YEAR(0) TO MONTH,
ITERVAL_YEAR INTERVAL YEAR(2) TO MONTH,
MAXITERVAL_YEAR INTERVAL YEAR(9) TO MONTH,
MININTERVAL_DAY INTERVAL DAY(0) TO SECOND(0),
INTERVAL_DAY INTERVAL DAY(2) TO SECOND(6),
MAXINTERVAL_DAY INTERVAL DAY(9) TO SECOND(9),
MAXRAW RAW(2000),
MINRAW RAW(1),
ROWID_ ROWID,
UROWID_ UROWID,
CLOB_ CLOB,
NCLOB_ NCLOB,
BLOB_ BLOB,
BFILE_ BFILE,
XMLTYPE_ XMLTYPE
)