Hi All,
ihave a simple query to db

select obj#, owner#, ctime from sys.obj$ o1
where obj# = (
select obj# from sys.obj$ o2
where o1.owner# = o2.owner#
and rownum = 1
-- order by ctime desc
)

but after remove commect on ORDER BY line i have error
ORA-00907 missing right parenthesis.
Can you help me to resolve this error ?