List all the table from oracle

To get all tables in oracle database then you can this query

select * from all_tables;

 

To ger all columns in oracle database 

select * from all_tab_cols;