Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Show Tables and others objects

rober584812
Member Posts: 491 Bronze Badge
I consider it convenient to implement the Show Tables command that allows a quick query of tables and other objects in a schema.
Comments
-
Show tables:
select table_name from user_tables
show object:
select object_type, object_name from user_objects;
-
Show tables:
select table_name from user_tables
show object:
select object_type, object_name from user_objects;
Very good, but simpler would be: show tables;
-
Very good, but simpler would be: show tables;
And even more: if the show pdbs command exists, why not a show tables?