Hi all.

Can anybody suggest an Oracle equivalent to the following sql query :



UPDATE Profile
SET LastSavedSearch =
(
SELECT TOP 1 ss.SavedSearch--, MAX(DATEADD(s, ssb.StartTime, ssb.StartDate))
FROM Profile p
INNER JOIN ProfileFile pf ON pf.ProfileFile = p.ProfileFile
INNER JOIN SavedSearchLoad ScheduleItem lsi ON lsi.DmsId = pf.DmsId
INNER JOIN SavedSearchLoad Schedule...