OraFAQ Forum: Client Tools » Sql developer hanging while quering table with clob

Home » Other » Client Tools » Sql developer hanging while quering table with clob (Sql Developer 1.2.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql developer hanging while quering table with clob [message #481022]

Fri, 29 October 2010 06:24

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

Report message to a moderator

Re: Sql developer hanging while quering table with clob [message #481028 is a reply to message #481022]

Fri, 29 October 2010 07:10

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

select dbms_lob.substr(your_clob_column,1,100) from your_table

Report message to a moderator

Previous Topic:	Problems in queries with CLOB fields
Next Topic:	2 Sessions for one connection ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:59:13 CST 2024