SQLDeveloper and CLOBs

From: nico torres <frasebook4@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 25 Apr 2014 12:19:15 -0300

Hi, I am new to LOB datatypes and I have a question about it:

I've read that in order to get clob data from the database, you need to get
it done in groups of 4000 characters, because of VARCHAR2 limitations.

Now, to my surprise, I just made a select clobcolumn from mytable, without
anything else, in Sqldeveloper, and it got the whole file

Could anyone explain this to me?


Thanks!

Follow-Ups:
- Re: SQLDeveloper and CLOBs
  - From: Mark Bobak
- Re: SQLDeveloper and CLOBs
  - From: Kim Berg Hansen

Other related posts:

» SQLDeveloper and CLOBs - nico torres
» Re: SQLDeveloper and CLOBs- Mark Bobak
» Re: SQLDeveloper and CLOBs- Kim Berg Hansen