OraFAQ Forum: Client Tools » Cannot save the data of the columns with CLOB datatype

Home » Other » Client Tools » Cannot save the data of the columns with CLOB datatype (Oracle 9i)

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

Cannot save the data of the columns with CLOB datatype [message #386718]

Mon, 16 February 2009 18:51

Ricky_1362002
Messages: 111
Registered: February 2009

Senior Member

I have a small query which gives me a result of about 7500 records.

I do that query in TOAD, and one of the developer needs the result of that query to be saved in excel file.

I did try to save it from the grid to an excel file but it is not saving because two of the columns in that table are of CLOB datatype.

I was successfull in saving the data without those two columns but the developer strictly wants data of those 2 columns too.

Is there anyway to export the data from the columns with CLOB datatype into an excel or some other type of file?

please help.

Thank You
-munna

Report message to a moderator

Re: Cannot save the data of the columns with CLOB datatype [message #386723 is a reply to message #386718]

Mon, 16 February 2009 19:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

One of the Posting Guidelines directs you SEARCH this forum &
use GOOGLE to this FAQ!

Report message to a moderator

Re: Cannot save the data of the columns with CLOB datatype [message #386730 is a reply to message #386718]

Mon, 16 February 2009 19:54

Ricky_1362002
Messages: 111
Registered: February 2009

Senior Member

i am sorry if i posted something wrong, please correct me where i went wrong in posting the topic.

And did you mean asking me to search that topic in google?

-thanks
munna

Report message to a moderator

Re: Cannot save the data of the columns with CLOB datatype [message #387060 is a reply to message #386718]

Tue, 17 February 2009 15:55

Ricky_1362002
Messages: 111
Registered: February 2009

Senior Member

Can anyone please suggest me what to do to export data from a table with columns of CLOB datatype. Need to do that from TOAD.

please help me.

-thanks
munna

Report message to a moderator

Re: Cannot save the data of the columns with CLOB datatype [message #387134 is a reply to message #387060]

Wed, 18 February 2009 00:34

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe it is a question to ask to Quest. http://www.toadsoft.com/ points to many TOAD specific forums.

Regards
Michel

Report message to a moderator

Previous Topic:	connecting to remote database server through sqlplus
Next Topic:	Can't initialize OCI. Error -1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:11:23 CST 2024