Re: Newbie question

On 25 Mar 1998 06:07:05 GMT, af169_at_FreeNet.Carleton.CA (Martin McGreal) wrote: Hi,

to import from an ASCII-File take a look at SQLLoader which is shipped with your oracle-sw.

>
>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

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de