Thanks for the question, %D0%A1%D0%B5%D1%80%D0%B3%D0%B5%D0%B8%CC%86.
Asked: January 26, 2018 - 2:19 am UTC
Last updated: January 27, 2018 - 2:20 am UTC
Version: 11g
Viewed 1000+ times
CREATE TABLE DBF_LOG_TST ( DBF_HEADER CLOB, DBF_DATA XMLTYPE ) XMLType COLUMN DBF_DATA STORE AS BASICFILE CLOB (TABLESPACE LOB STORAGE (INITIAL 64 K MAXEXTENTS UNLIMITED));
CREATE INDEX IDX_DBF_LOG_DocumentElement ON DBF_LOG_TST(DBF_DATA) INDEXTYPE IS XDB.XMLIndex PARAMETERS ('paths (include (/DocumentElement/table))');
%D0%A1%D0%B5%D1%80%D0%B3%D0%B5%D0%B8%CC%86 %D0%A3%D1%81%D1%82%D0%B8%D0%BD%D0%BE%D0%B2, January 26, 2018 - 6:49 pm UTC
New to good database design? Check out Chris Saxon's full fundamentals class.