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

Thank you both for answering. I have already re-created the table with the field type Varchar2 length 1000.
Simply for curiosity, when I copy a string shorter then 1000 into this field, will Oracle use memory necessary to store the string, or to store 1000 characters long string? Sorry for silly question, I understand that I could have found it somewhere... Galina
galkas_at_mail.ru (Galina) 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
Received on Tue May 04 2004 - 14:57:00 CEST