Not load LOB/BLOB/CLOB with "SELECT *" - Allround Automations forums

Hi everybody,

talking about PL/SQL Developer versions 11.0.6 and 12.0.7, how can I avoid that when I do a

SELECT * FROM MY_TABLE_WITH_SOME_LOB_COLUMN

the BLOB/CLOB_COLUMN's content is automatically fetched?
Most of the times, this is not what I want - I only want to have a glance at some numeric or character columns.

Oracle's SQL Developer loads the LOB columns only on demand, and that's what I would like to configure in PL/SQL Developer, too, since I work a lot over a mobile network.

Thanks a lot,
Andreas

Ah the times i've been stung with this!
Hope there's a solution other than having to being specific with the columns in the select.

Hi,

in case of 'variable' selects i use &Variables. Here is stmt.statement the clob column.

Code

select ...
 ,&< name = "Statement Clob" 
     hint = "with clob?" 
     list = "    NULL           ""Statement Full""    ,N
              ,""stmt.statement ""Statement Full"" "" ,J 
            " 
     description=YES 
     DEFAULT = "N"
   > 
...