RE: SQL question

From: Singla, Sanjeev <SSingla_at_oxhp.com>
Date: Thu, 22 Jun 2000 10:45:11 -0400
Message-Id: <10536.110147@fatcity.com>

Try

update COMPANY b
set PATH = (select PATH || '/BBB' from COMPANY a where b.MANAGER_ID = a.ID) where NAME='BBB'

-----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 . Received on Thu Jun 22 2000 - 09:45:11 CDT