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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL question

RE: SQL question

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 22 Jun 2000 10:58:22 -0400
Message-Id: <10536.110158@fatcity.com>


Create a PL/SQL function which will return the proper value and use it in the update statement.

-----Original Message-----

From: Andrey Bronfin [mailto:bronfin_at_VisualTop.com] Sent: Thursday, June 22, 2000 10:57 AM
To: Multiple recipients of list ORACLE-L Subject: SQL question

Hi , DBAs !
I've got a SQL question :
There is a table called COMPANY :  

NAME ID MANAGER_ID PATH


AAA        5            2                /home/AAA
BBB        10          5                NULL
 

I want to perform something like :
update COMPANY b
set PATH = (select PATH from COMPANY a where b.MANAGER_ID = a.ID)||'/BBB' where NAME='BBB' ;  

It should update the PATH column for BBB to be ' /home/AAA/BBB'  

The query does not work this way . I recieve the error message : ERROR at line 1:
ORA-00933: SQL command not properly ended  

Is there a way to do it ?  

Thanks !  

For statistics : i'm from Tel-Aviv , Israel .

Andrey Bronfin Received on Thu Jun 22 2000 - 09:58:22 CDT

Original text of this message

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