Re: Newbie question

Ditto previous responses on SQL*Loader; however, one thing you should know about is the @ symbol. Say your file is c:\mydocs\temp_sql.txt, then, from the command prompt type:

@c:\mydocs\temp_sql.txt

This will execute the contents of the text file.

Also, type:

edit new_sql_file

to get a new file *orahome*\bin\new_sql_file.sql, where *orahome* is your oracle home directory.

Then, type:

@new_sql_file

to execute that file.

You may have to place a / at the end of certain pl/sql blocks to get them to execute (create procedure, for example).

Best of luck,

Ben Salemi
Global Consulting Group

In article <6fa6u9$s6n_at_freenet-news.carleton.ca>,   af169_at_FreeNet.Carleton.CA (Martin McGreal) wrote:
>
>
> I have my first table setup and a large ascii file of data converted to
> the sql insert command:
>
> insert into table values (...); etc.
>
> My question is how do I convert this ascii file to sql and then bring it
> into sql plus to start it moving?
>
> I started off cutting and pasting but I have too much data for this approach
> as the buffer can only take so much data per cut and paste.
>
> I am using notepad and was aware of the little trick of using the "edit"
> command to call it up. (I had to learn this one too! ;)
>
> thanks,
>
> --
> Martin McGreal
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 25 1998 - 00:00:00 CST