Newbie question

On 25 Mar 1998 06:07:05 GMT, 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

Try loading the data with SQL*LOAD instead of INSERT statements. It's much easier. Received on Wed Mar 25 1998 - 00:00:00 CST