/ * Find the desired Object * /
Col Object_name Form A30
Col Object_Type Form A30
Select Object_name, Object_Type from DBA_OBJECTS
Where object_name like '% & object_name%'
And Object_Type in ('Table', 'View');
