The following code queries the USER_OBJECTS data dictionary view.
SQL> SQL> select object_name, object_type 2 from user_objects 3 where object_type in ('TABLE','VIEW') 4 and ROWNUM < 10-- w w w . j a v a 2 s . c om 5 order by object_type, object_name ; OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE ------------------- ACCESS$ TABLE ALERT_QT TABLE ALL_ALL_TABLES VIEW OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE ------------------- ALL_APPLY VIEW ALL_APPLY_CHANGE_HANDLERS VIEW ALL_APPLY_CONFLICT_COLUMNS VIEW OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE ------------------- ALL_APPLY_DML_CONF_HANDLERS VIEW ALL_APPLY_DML_HANDLERS VIEW ALL_APPLY_ENQUEUE VIEW 9 rows selected. SQL>