display entire CLOB in SQL Plus Worksheet or SQL Plus

i would like to display a clob field (approx 4k chars) in full in sql plus worksheet.

googled around and had a look at Oracle SQL Plus manual and couldn't find anything relevant (plenty for long fields however) or worked.

query is:
select myclob from mytable;

could i have the syntax to display entire field not first 80 chars please?

Edwinah63 Received on Mon Sep 05 2005 - 00:56:57 CDT