/SQL/How to get all the tables displayed in oracle

How to get all the tables displayed in oracle

Show all tables in oracle

SELECT * FROM USER_TABLES;		-- Tables from connected schema
SELECT * FROM ALL_TABLES;		-- Tables available to connected schema
	SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
	SELECT * FROM ALL_TABLES WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All database Tables

Source: grepper.com

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Source: grepper.com

Similar codes

0 vote386 views1 answer
Osm2pgsql mac
SQL
6 votes320 views1 answer
Allsource oracle
SQL
9 votes318 views3 answers
Sequence postgresql
SQL
1 vote340 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote337 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote702 views1 answer
Sql field equals multiple values
SQL
0 vote320 views1 answer
Sql inserted
SQL
0 vote360 views1 answer
Oracle current timestamp insert statement
SQL
1 vote332 views1 answer
Too many connections mysql
SQL
0 vote352 views1 answer
Add timestamp column to existing table t-sql
SQL