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

"Edwinah63" <edwinah_at_customercare.com.au> a écrit dans le message de news: 1125899817.666357.69610_at_o13g2000cwo.googlegroups.com...
|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 Received on Mon Sep 05 2005 - 01:11:24 CDT