Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL IN ORACLE
"ap" <alberto_at_momax.it> wrote in message
news:975fed$re3$1_at_fe1.cs.interbusiness.it...
> WHY THIS SQL NOT RUNNING IN ORACLE???
>
> UPDATE table_dest A
> SET A.column_1 = B.column_1
> WHERE EXISTS
> ( SELECT * FROM table_orig B
> WHERE A.PK=B.PK)
it won't run because it is an invalid SQL statement. that's why.
>
> THE ERROR MESSAGE IS :
> INVALID COLUMN NAME
>
> EXISTS ANOTHER SIMILAR SQL FOR UPDATE
> FROM ONE TABLE TO ANOTHER IDENTICAL TABLE ???
>
> TANKS
>
you could try a statement something like this:
UPDATE table_dest A
SET A.column_1 = (SELECT B.column_1
FROM table_orig B WHERE A.PK = B.PK)HTH Received on Sat Feb 24 2001 - 17:04:19 CST