Home » SQL & PL/SQL » Client Tools » Sql developer hanging while quering table with clob (Sql Developer 1.2.1)
Sql developer hanging while quering table with clob [message #481022] Fri, 29 October 2010 06:24 Go to next message
sam_2168
Messages: 1
Registered: October 2010
Location: India
Junior Member
I have some tables which have LOB columns.

For eg: Transmission.

When i query
select * from Transmission where rownum < 2. it hangs

Even thought it retrieves 1 record, its hanging because of CLOB column. I tried find settings but couldnt.

Did any face similar problem? Where i can do any settings? is there a facility to set CLOB limit ?

Thanks in advance
Sam
Re: Sql developer hanging while quering table with clob [message #481028 is a reply to message #481022] Fri, 29 October 2010 07:10 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
select dbms_lob.substr(your_clob_column,1,100) from your_table
Previous Topic: Problems in queries with CLOB fields
Next Topic: 2 Sessions for one connection ?
Goto Forum:
  


Current Time: Mon Dec 06 18:33:31 CST 2021