Hi,

How can write this Sybase statement in Oracle (8.1.7)?

mcl

update ITX_APPLICATION_PATH set
APPLICATION_ID = (select APPLICATION_ID from ITX_APPLICATION where APPLICATION_NAME = B.APPLICATION_NAME),
PATH_TYPE = B.PATH_TYPE,
PHYSICAL_PATH = B.PHYSICAL_PATH,
DESCRIPTION = B.DESCRIPTION,
ITX_VERSION = ITX_VERSION+1,
ITX_MODULE = B.ITX_MODULE
from ITX_APPLICATION_PATH A, VIP_APPLICATION_PATH B
where A.PATH_NAME = B.PATH_NAME;