select rownum NO, OBJECT_NAME
from
(
select distinct OBJECT_NAME from all_procedures
where owner=’DBADMIN’
order by OBJECT_NAME
)
pengetahuan, tv, sepakbola, Indonesia, film, selebritis, koran, games, kehidupan, paparazi dll
select rownum NO, OBJECT_NAME
from
(
select distinct OBJECT_NAME from all_procedures
where owner=’DBADMIN’
order by OBJECT_NAME
)