Oracle supplies a command-line utility for loading data. You will find this in
the "bin" sub-directory of your ORACLE_HOME directory.
ORACLE_HOME is an environment variable which hold the actual name of the
directory where the Oracle software is installed on your workstation. Open a
Command (DOS) window and type "set", then hit the Enter key, and all your
environment variables and associated values will display. On my computer, the
ORACLE_HOME line looks like this:
ORACLE_HOME=D:\oracle\ora90
So on my computer, I look in D:\oracle\ora90\bin to find a program called
"SQLLDR.EXE"
In order to load data from your Excel file, you must follow these steps:
1) Save the Excel spreadsheet to a text format, (e.g., csv, fixed-width, etc.)
2) Prepare a SQL*Loader control file
3) Execute SQL*Loader at a command prompt, passing the database connection,
login information (user name and password), and the path to your control file.
Details on these should be in the Oracle docs, I'm looking at a book from
O'Reilly Press called Oracle SQL*Plus where the topic is covered on pages
167-174.
--
Charles Knell
cknell(_at_)onebox(_dot_)com - email
-----Original Message-----
From: "Marty McKeever" <marty(_dot_)mckeever(_at_)goingv(_dot_)com>
Sent: Thu, 13 Feb 2003 08:22:44 -0500
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: [xsl] node-setting() escaped text
Interesting problem i need to solve, either on the front end or the backend,
not sure which. I just had an idea that "might" work, front-end, if i could
figure out how.
Sample DOM:
<page>
<item>
<html>
text-node containting escaped html
</html>
</item>
</page>
Knowing in advance that the escaped HTML is well-formed, is there any way to
evaluate this text-node string into a node-set and apply-templates upon it?
Something like this perhaps?
<xsl:apply-templates select="xx:node-set(unescape(//item))"/>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list