Advertisement
Guest User

Untitled

a guest
Mar 19th, 2019
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.76 KB | None | 0 0
  1. BEGIN
  2.     ctx_ddl.create_preference('htmgroup2','FILE_DATASTORE');
  3.     ctx_ddl.set_attribute('htmgroup2','PATH','C:\app\OracleUser\admin\orcl\dpdump');
  4.     ctx_ddl.create_section_group('htmgroup2', 'HTML_SECTION_GROUP');
  5.     ctx_ddl.add_zone_section('htmgroup2', 'heading', 'H1');
  6. END;
  7.  
  8. DROP TABLE htmlprova;
  9.  
  10. CREATE TABLE htmlprova(
  11. id NUMBER PRIMARY KEY,
  12. docs CLOB);
  13.  
  14. INSERT INTO htmlprova VALUES(1, 'CiaoMondo.html');
  15. INSERT INTO htmlprova VALUES(2, 'CiaoOracle.html');
  16.  
  17. CREATE INDEX myindex ON htmlprova(docs) indextype IS ctxsys.context
  18. parameters('filter ctxsys.null_filter section group htmgroup');
  19.  
  20. -------------------
  21. anonymous block completed
  22.  DROP TABLE htmlprova succeeded.
  23. CREATE TABLE succeeded.
  24. 1 ROWS inserted
  25. 1 ROWS inserted
  26. CREATE INDEX succeeded.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement