Frank,

Still have some issues that need resolving..so I'll wait until I resolve
them all. Right now I am real close. The only thing that I cannot do is
log into the apps !!!! Big problem I know, but I feel I am getting very
close.


"Frank" <fvanbortel (AT) netscape (DOT) net> wrote

In article <3EF75784.9040004 (AT) netscape (DOT) net>,
Frank <fvanbortel (AT) netscape (DOT) net> wrote:

I am stumped. I am a very very new Oracle user. A colleague put the
Oracle 10g client on my workstation (Windows XP) this afternoon. I was
able to start the client and access a remote database that was created
as a test bed for me. I was able to create a simple table with four
columns. Now, I have a text file, delimited by semicolons, that I want
to import into the table that I created via SQL*Plus, but figuring out
how to do that seems to be a real challenge.

I have been googling for a solution to this problem, but all I find is
something about an SQL Loader, which I cannot find on my PC. I do not
have discs to load it, all I have is what was loaded on my PC.

Isn't there a way to use the insert statement from within SQL*Plus that
does something along the lines of

insert into table x from file y delimited by ';'
(field1, field2, field3, field4);

?

I don't care about insert performance. This table was built without any
constraints or indexes. Its just two varchar2(20) columns and two number
columns, so its about as simple as one can get.

Do I really need a separate utility to do this task, or is there some
way to do it entirely within SQL*Plus via insert or some other command?
Also, how do I use the help feature in SQL*Plus? If I type "help insert"
it says invalid topic and if I type "help" it says I can get help on a
topic? How exactly does this help feature work? Its not very helpful!

On Thu, 03 Aug 2006 17:32:35 -0400, Shawn Hirn <srhi (AT) comcast (DOT) net>
wrote:

included with the *administrator* client, not with the normal client.
However, sql*loader is going to work only if the input is *on the
server*


You could set up an external table. But then again, the input file
again needs to be on the server.
If you don't want that, Oracle has a free tool (on
http://otn.oracle.com) called 'Oracle Application Express' that will
allow you to upload csv files via your browser.

There is help in sql*plus on sql*plus itself. There is *no help* on
SQL as that would be *huge*.
There is a SQL reference manual (and many other volumes of
documentation) up on http://tahiti.oracle.com
Info on Sql*loader and external tables is in the Oracle Server
Utilities Manual.

--
Sybrand Bakker, Senior Oracle DBA