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:
Post a Comment