Home » SQL & PL/SQL » SQL & PL/SQL » Data Conversion (Oracle 10g)
Data Conversion [message #327640] Tue, 17 June 2008 02:15 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

Hi Experts

I need to convert Long data Type Column to Varchar2 data type.
Is there any way to achive it by SQl only because I have to do it by SQL only, don't have any permission to create pl/sql block.

Thanks in Advanve !

Regards
Rajat
Re: Data Conversion [message #327648 is a reply to message #327640] Tue, 17 June 2008 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Is there any way to achive it by SQl only

No.
PL/SQL (if data < 32K) or other programming language is mandatory.

Regards
Michel
Re: Data Conversion [message #327675 is a reply to message #327648] Tue, 17 June 2008 03:50 Go to previous message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

THANKS MICHEL to confirm.
Previous Topic: Index
Next Topic: join
Goto Forum:
  


Current Time: Thu Feb 13 13:19:12 CST 2025