Get all table name in oracle

If you are using Microsoft SQL Server you can use one of these queries.

SELECT *
FROM sys.tables

or

SELECT *
FROM sysobjects
WHERE xtype = 'U'

---

If you are using Oracle, you can use one of these:

SELECT *
FROM all_tables;

or

SELECT *
FROM all_objects
WHERE object_type = 'TABLE';