Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
|
Using XSQL Servlet, 13 of 24
To set up the demo data do the following:
GRANT EXECUTE ON CTX_DDL TO SCOTT;
GRANT QUERY REWRITE TO SCOTT;
This allows SCOTT to create a functional index that one of the demos uses to perform case-insensitive queries on descriptions of airports.
install.sql
in the ./xsql/demo directory. This script runs all SQL scripts for all the demos.
install.sql @@insclaim/insclaim.sql @@document/docdemo.sql @@classerr/invalidclasses.sql @@airport/airport.sql @@insertxml/newsstory.sql @@empdept/empdeptobjs.sql
imp scott/tiger file=doyouxml.dmp
to import sample data for the "Do You XML? Site" demo.
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|