Home » SQL & PL/SQL » SQL & PL/SQL » convert clob to string
convert clob to string [message #304036] Mon, 03 March 2008 16:35 Go to next message
miroconnect@yahoo.com
Messages: 195
Registered: April 2006
Senior Member
how to convert clob to string ?

Report message to a moderator

Re: convert clob to string [message #304038 is a reply to message #304036] Mon, 03 March 2008 17:29 Go to previous messageGo to next message
ThomasG
Messages: 2886
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
A clob already is a string.

If you are really talking a about varchar2 / char data types look at the explicit conversion functions

Report message to a moderator

Re: convert clob to string [message #304097 is a reply to message #304036] Tue, 04 March 2008 00:48 Go to previous message
Michel Cadot
Messages: 54246
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A CLOB is a string.
What is your actual problem?

Regards
Michel

Report message to a moderator

Previous Topic: Moving Clustered tables from one tablespace to another
Next Topic: SQL query for collection load
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 09:52:52 CDT 2013

Total time taken to generate the page: 0.18085 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.