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

Register Log In

Forums Products PL/SQL Developer Not load LOB/BLOB/CLOB with "SELECT *"

Print Thread

Not load LOB/BLOB/CLOB with "SELECT *" #57534 02/16/18 02:30 PM
Joined: Jul 2016 Posts: 3 A awi64 OP Member
OP awi64 Member A Joined: Jul 2016 Posts: 3	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

Re: Not load LOB/BLOB/CLOB with "SELECT *" awi64 #57535 02/16/18 03:31 PM
Joined: Jun 2007 Posts: 61 Sheffield I IncredibleMrT Member
IncredibleMrT Member I Joined: Jun 2007 Posts: 61 Sheffield	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.

Re: Not load LOB/BLOB/CLOB with "SELECT *" IncredibleMrT #57564 02/20/18 09:44 AM
Joined: Mar 2007 Posts: 210 Rostock, Germany Theod Member
Theod Member Joined: Mar 2007 Posts: 210 Rostock, Germany	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" > ... There is no shortcut for experience(d). PL/SQL Developer Version 10+11+12, Query Reporter Version 3.2.0.300 Oracle 11g,12c Windows Server 2003/2008 Windows 10 Professionel 64 bit

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 14 (0.008s) Memory: 2.5030 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-05-10 08:36:15 UTC
Valid HTML 5 and Valid CSS