How to Show Tables in Oracle
Method 1
select * from user_tables;
select * from user_tables where user='
UserName
';
Method 2
select * from user_objects where object_type = 'TABLE';
Oracle How To