Tuesday, March 06, 2007

How to view all the oracle tables in a schema?

In MySQL, we can use commands like "show tables" to view all the tables in the current database. However, when I tried to find such a command in the Oracle documentation, i didn't succeed.
I'm not should if there is such a command.
But if you want to display all the oracle tables, here's the sql statement you should use:
SELECT table_name FROM tabs;

No comments: