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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Do I need to create a field type LONG?

Re: Do I need to create a field type LONG?

From: x <x_at_x.hr>
Date: Thu, 29 Apr 2004 15:35:47 +0200
Message-ID: <c6r09i$msf$1@ls219.htnet.hr>


"Galina" <galkas_at_mail.ru> wrote in message news:ecdc865.0404290204.79ae76df_at_posting.google.com...
> Hello
> I am going to copy a data from MS Access table into Oracle table. One
> of fields is memo type and data in this field range from 1 character
> to 551 long string. Do I need to create a field type LONG in the
> Oracle table to accommodate this data? If not, what field type would
> suit best?
> Any help will be greatly appreciated.
> Thank you.
> Galina

varchar2 should be enough, iz can store up to 4000 characters. Received on Thu Apr 29 2004 - 08:35:47 CDT

Original text of this message

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