Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- ctx_ddl.create_preference('htmgroup2','FILE_DATASTORE');
- ctx_ddl.set_attribute('htmgroup2','PATH','C:\app\OracleUser\admin\orcl\dpdump');
- ctx_ddl.create_section_group('htmgroup2', 'HTML_SECTION_GROUP');
- ctx_ddl.add_zone_section('htmgroup2', 'heading', 'H1');
- END;
- DROP TABLE htmlprova;
- CREATE TABLE htmlprova(
- id NUMBER PRIMARY KEY,
- docs CLOB);
- INSERT INTO htmlprova VALUES(1, 'CiaoMondo.html');
- INSERT INTO htmlprova VALUES(2, 'CiaoOracle.html');
- CREATE INDEX myindex ON htmlprova(docs) indextype IS ctxsys.context
- parameters('filter ctxsys.null_filter section group htmgroup');
- -------------------
- anonymous block completed
- DROP TABLE htmlprova succeeded.
- CREATE TABLE succeeded.
- 1 ROWS inserted
- 1 ROWS inserted
- CREATE INDEX succeeded.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement