From: kennedy-downwithspammersfamily@attbi.net   
      
   "Galina"  wrote in message   
   news:ecdc865.0405040457.25b3d48a@posting.google.com...   
   > 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@mail.ru (Galina) wrote in message   
   news:...   
   > > 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   
   It stores the string as is.  It does not pad the string.  So if the string   
   is of length 2 then it takes up 2 (plus one for the column delimiter)   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)