I am a total newbie to the Oracle world. I have a table with a field that needs to accomdate possibly 64k of data. I was told to use a CLOB field for this. Now, when I am trying to view the data in the field using a SELECT statement in SQLPlus worksheet, I only get 80 characters of data for that field. Is it possible to retrieve all of the data in that field using a SELECT statement in SQLPlus worksheet? If so, how??