root of Tree

UPDATE SVR_DEVICES
SET SURPLUS_DATE = SYSDATE
WHERE DEV_ID = :P3_DEV_ID;











I founded old way only:

Select DEV_ID + 20000 id,

ROOM + 10000 PID,

HOST_NAME name,

'f?p=&APP_ID.:6:&SESSION.::NO::P6_DEV_DEV_ID:'||dev_ID AS link,

null AS a1,

null AS a2

from SVR_DEVICES

UNION

Select ROOR_ID + 10000 id,

SITR_SITR_ID PID,

ROOM name,

null AS link,

null AS a1,

null AS a2

from SVR_ROOMs_RF

union

select 0 ID,

0 PID,

'All Cities' name,

null AS link,

null AS a1,

null AS a2

from SVR_SITES_RF where rownum = 1

UNION

select SITR_ID ID,

0 PID,

city name,

null AS link,

null AS a1,

null AS a2

from SVR_SITES_RF

order by name