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

8 votes131 views3 answers
Postgresql connection string c#
SQL
3 votes97 views1 answer
Postgresql where current year
SQL
0 vote140 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote141 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote147 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote127 views1 answer
Sql alchemy with azuresql server
SQL
0 vote124 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote137 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote151 views1 answer
Mysqldump don't drop table
SQL
0 vote140 views1 answer
Delete record by id sql
SQL