Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL IN ORACLE

SQL IN ORACLE

From: ap <alberto_at_momax.it>
Date: Fri, 23 Feb 2001 11:58:28 +0100
Message-ID: <975fed$re3$1@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)


THE ERROR MESSAGE IS :



INVALID COLUMN NAME


EXISTS ANOTHER SIMILAR SQL FOR UPDATE



FROM ONE TABLE TO ANOTHER IDENTICAL TABLE ???


TANKS

Received on Fri Feb 23 2001 - 04:58:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US