The text you gave at the start strongly implies that the original problem was a missing bracket. On the query format, why not just use:
Code:select obj#, owner# from sys.obj$ o1 where ctime = (select max(o2.ctime) from sys.obj$ o2 where o2.obj# = o1.obj# and o2.owner# = o1.owner#)




Reply With Quote