Below query to get the list of custom tables in oracle application.
Query:
select object_name,
object_type
from all_objects
where 1=1
and object_type='TABLE'
and status='VALID'
and object_name like 'XXCUST%';
Query:
select object_name,
object_type
from all_objects
where 1=1
and object_type='TABLE'
and status='VALID'
and object_name like 'XXCUST%';
No comments:
Post a Comment