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

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1012703

Regards
Michel Cadot


.