Oracle user tables

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 TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All Tables

Similar codes

0 vote229 views1 answer
Report in database
SQL
9 votes217 views5 answers
Sql limit
SQL
0 vote221 views4 answers
Mysql on kubernetes
SQL
0 vote236 views1 answer
Oracle dynamic select into
SQL
0 vote242 views1 answer
Select new table sql
SQL
2 votes225 views1 answer
Sql server current date minus 5 years
SQL
1 vote209 views1 answer
Oracle index partition
SQL
2 votes214 views3 answers
Postgresql reset auto increment
SQL
0 vote207 views1 answer
Drop specific row postgresql
SQL
0 vote206 views1 answer
SQL Error 1040 : Too many connections
SQL