Me on Information Tech

You can select list of tables from all the different schemas in your oracle database, here’s how SELECT all_tables FROM all_tab_columns; or get all the table details SELECT * FROM all_tab_columns;