MySQL “Show Tables” on Oracle

SELECT table_name FROM tabs

alternative:

• SELECT * FROM tabs
• SELECT * FROM user_objects WHERE object_type = ‘TABLE’

Source:

http://forums.devshed.com/oracle-development-96/show-tables-in-oracle-135613.html