Home » SQL & PL/SQL » Client Tools » Cannot save the data of the columns with CLOB datatype (Oracle 9i)
Cannot save the data of the columns with CLOB datatype [message #386718] Mon, 16 February 2009 18:51 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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!
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: connecting to remote database server through sqlplus
Next Topic: Can't initialize OCI. Error -1
Goto Forum:
  


Current Time: Sat Dec 03 01:34:09 CST 2016

Total time taken to generate the page: 0.10503 seconds