Query to copy columns from one table to another table [message #364768] |
Wed, 10 December 2008 00:26  |
ashamg2k
Messages: 18 Registered: October 2007
|
Junior Member |
|
|
Hi All,
I have a table test1 which has a column view_text1 of long data type.
But i am not able to query this column using the like operator.
select * from test1 where view_text1 like '%V%'
As a workaround i created another table test2 which has a column view_text2 of varchar2(4000)
Now i want to copy the view_text1 column data of test1 table to view_text2 column of test2 table.
Please let me know what query should i write.
Thanks in advance,
Asha
|
|
|
|
|
|