Query to list all tables in oracle database
In this post , I am sharing the sql query to list all tables in oracle database. When we creates the Table in Oracle Database then oralce database insert new record in the DBA_OBJECTS table with the name of the table. It also create new record in the DBA_TABLES table. DBA_TABLE is only specific for the tables in the Oracle database. Here below i am sharing the SQL query which helps to list all tables in oracle database.
Query to list all tables in oracle database
SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE'
This sql script list all the tables of the Oracle Database with the Date of Creation in Oracle database.
0 comments:
Post a Comment