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