Re: Converting Varchar2 datatype into Clob datatype

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Thu, 11 Apr 2002 23:23:44 GMT
Message-ID: <4Wot8.3620$r76.1776214139@newssvr14.news.prodigy.com>

Rajesh,

Here is nice post about that:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3cb5a0f549abffff;act=ST; f=15;t=89

It is reading LONG into VARCHAR and then writting to CLOB. You can use it to read VARCHAR into VARCHAR then to CLOB.

Check the latest Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Rajesh Khanna" <rajesh.khanna_at_fritz.com> wrote in message news:3cb5c02b$0$15767$4c41069e_at_reader0.ash.ops.us.uu.net...
> Hi
>
> How we can convert VARCHAR2 datatype into CLOB datatype.
>
> Thanks in Advance.
>
> Rajesh
>
>
>
Received on Thu Apr 11 2002 - 18:23:44 CDT