| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Do I need to create a field type LONG?
"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
![]() |
![]() |