Home » SQL & PL/SQL » SQL & PL/SQL » update data from LONG to VArchar2 (ORALCLE9i)
update data from LONG to VArchar2 [message #343776] Thu, 28 August 2008 02:11 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Hi.
I have one table TEST in which one column is of Datatype LONG
and other is Varchar2

I want to update data from LONG datatype column to varchar2 datatype column .
HOw to update it

Table name :Product
column
product_id number
Disc LONG
Disc_detail varchar

I want to update Disc data to DIsc_details.
Re: update data from LONG to VArchar2 [message #343780 is a reply to message #343776] Thu, 28 August 2008 02:20 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do it in SQL, you have to add PL/SQL or other language code.
This is why it is said for more than 10 years: don't use LONG use CLOB.

Regards
Michel
Previous Topic: Difference between two dates
Next Topic: DATATYPES
Goto Forum:
  


Current Time: Sat Dec 10 05:17:43 CST 2016

Total time taken to generate the page: 0.10846 seconds