Oracle get table schema

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

Similar codes

4 votes306 views2 answers
Tsql utf to local time
SQL
0 vote296 views1 answer
Oracle running queries sql
SQL
0 vote336 views1 answer
For row in sql database python loop
SQL
3 votes286 views1 answer
Oracle rollback
SQL
1 vote269 views1 answer
Autocommit mysql
SQL
0 vote290 views2 answers
Sql use not in
SQL
1 vote277 views1 answer
Mysql show current queries
SQL
0 vote316 views1 answer
How to install postgresql on wsl
SQL
9 votes277 views4 answers
Mysql show table fields
SQL
0 vote278 views1 answer
Sql query with date
SQL