When i'm running SQL Server i can query the server (master db) to find out what databases there are using an SQL window. Can this be done in an oracle workbook?

Also i can query to find out what tables there are in the current database by selecting from either all_all_tables or all_tables. What is the difference between these tables(views)?