Not load LOB/BLOB/CLOB with "SELECT *"

[awi64]

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

 

[IncredibleMrT]

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.

 

[Theod]

Hi,

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

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