0

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
)
user2672165
  • 2,986
  • 19
  • 27
Denis
  • 129
  • 1
  • 4
  • 12

0 Answers0