Setting up XMLType columns
Hi, could somebody please assist me with setting up my schema objects,
(
test_id NUMBER (18) NOT NULL ,
testXML XMLTYPE NOT NULL
) tablespace outputs
XMLType COLUMN testXML STORE AS CLOB testXMLseg(
TABLESPACE outputs
STORAGE ( INITIAL 4096 NEXT 4096)
CHUNK 4096 NOCACHE LOGGING
INDEX testXML_idx (
TABLESPACE outputs
STORAGE ( MAXEXTENTS UNLIMITED )
)
);
TABLE TEST
(
test_id NUMBER (18) NOT NULL ,
testXML XMLTYPE NOT NULL
) tablespace outputs
XMLType COLUMN testXML STORE AS CLOB testXMLseg(
TABLESPACE outputs
STORAGE ( INITIAL 4096 NEXT 4096)
CHUNK 4096 NOCACHE LOGGING
INDEX testXML_idx (
TABLESPACE outputs
STORAGE ( MAXEXTENTS UNLIMITED )
)
);
table_name "Table"
I have the following table
CREATE TABLE TEST(
test_id NUMBER (18) NOT NULL ,
testXML XMLTYPE NOT NULL
) tablespace outputs
XMLType COLUMN testXML STORE AS CLOB testXMLseg(
TABLESPACE outputs
STORAGE ( INITIAL 4096 NEXT 4096)
CHUNK 4096 NOCACHE LOGGING
INDEX testXML_idx (
TABLESPACE outputs
STORAGE ( MAXEXTENTS UNLIMITED )
)
);
TABLE TEST
(
test_id NUMBER (18) NOT NULL ,
testXML XMLTYPE NOT NULL
) tablespace outputs
XMLType COLUMN testXML STORE AS CLOB testXMLseg(
TABLESPACE outputs
STORAGE ( INITIAL 4096 NEXT 4096)
CHUNK 4096 NOCACHE LOGGING
INDEX testXML_idx (
TABLESPACE outputs
STORAGE ( MAXEXTENTS UNLIMITED )
)
);
when I run the following query ....
SELECTtable_name "Table"
0