XML SQL Utility - Client
version
Demo type: command line
Run: login as "oracle"
cd /localb/oracle/app/oracle/product/8.1.5
source
xmlsql/OracleXSU/unixenv.csh
a) generate XML from table of database
command format:
java OracleXML
getXML [-withDTD] [-user "scott/tiger"] \
"select * from emp"
for example:
java OracleXML
getXML -user "scott/tiger" "select * from emp"
b) insert XML file into table of database
command format:
java OracleXML
putXML [-user "scott/tiger"] XMLFile tableName
for example:
java OracleXML
putXML -user "scott/tiger" \
-filename b.xml roman-table
Comment: OracleXML are loaded into the database |