Tables: //Table info
SQL SELECT * FROM dba_tables;

Tables_Columns: //Column info
SELECT * FROM all_tab_cols;