Re: ADD DATA FROM 1 COLUMN TO OTHER

Reiro wrote:
> Hi
>
> I have test table with three columns NAME, NAME2 and NAME3 :set out as
> follows:
>
> NAME NAME2
>
> ridwan thandeka
> irfhan Jimmy
>
>
> i need the data in a third column NAME 3 as follows:
>
> NAME3
>
> ridwan
> irfhan
> thandeka
> jimmy
>
>
> plz help....
> thanks in advance... :)

First:
SQL> SELECT keyword

   2 FROM v$reserved_words
   3 WHERE keyword LIKE 'NA%';

Second:
So use an update statement. Examples in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)