To get data base object information

 

To get data base object information

select * from dba_objects where object_name like '%NNNN%' and object_type = 'TABLE'