Oracle equivalent of information_schema.tables
Oracle indeed doesn't provide the information_schema
views, but has its own data dictionary. You can use all_tables
to create a similar query:
SELECT *
FROM all_tables
WHERE num_rows > 1
Oracle indeed doesn't provide the information_schema
views, but has its own data dictionary. You can use all_tables
to create a similar query:
SELECT *
FROM all_tables
WHERE num_rows > 1