I usually work with MySQL databases. I need to move one of our web applications into an Oracle database. All I need to know is how I can display all existing tables in a database that I created.

In MySQL all I have to type in is :

SQL> show tables;

It does not seem to be this simple in Oracle.
Someone please help thank you.