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: 64106
Registered: March 2007
Location: Nanterre, France, http://...
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: Mon Dec 05 02:35:32 CST 2016

Total time taken to generate the page: 0.07638 seconds