Re: display entire CLOB in SQL Plus Worksheet or SQL Plus

"Edwinah63" <edwinah@xxxxxxxxxxxxxxxxxxx> a écrit dans le message de news: 1125899817.666357.69610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|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

set long 10000

Michel Cadot