Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: inserting text data into oracle table

Re: inserting text data into oracle table

From: <mpir_at_compuserve.com>
Date: 1998/03/20
Message-ID: <6ett17$kj$1@nnrp1.dejanews.com>#1/1

how big is the 'long' field. If it is <2000 bytes, then you could consider using a VARCHAR2 field instead.

In article <6es1nl$pqr$1_at_murrow.corp.sgi.com>,   agwin_at_roddy.corp.sgi.com (Allyson Gwin) wrote:
>
> This is my first time on this newsgroup so forgive me if this has already
> been answered.
> I have a flat file that has a unique id (integer) and a text field in it
> (this field is very big). I have a table with 2 columns - an integer and a
> long. How can I get the data from the file into the table? I tried just
> using a regular sqlldr control file, but that didn't work. There are about
> 4000 records in this file. Some of the text fields have hard returns in
> them. If more information is needed, I can give a sample of the file.
> I am using Oracle7 Server Release 7.3.3.0.0. Thanks.
>
> Allyson
> --
> :-)
>
> **********************************************
> * Allyson Gwin | Silicon Graphics *
> * agwin_at_corp.sgi.com | WorldWide Field I/S *
> * | (650) 933-6177 *
> **********************************************
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US