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

0 vote140 views1 answer
Ignore case in string sql
SQL
0 vote139 views2 answers
Pl sql auto increment
SQL
1 vote221 views3 answers
Showing all columns in an sqlite table
SQL
1 vote149 views1 answer
Moodle query first user access
SQL
0 vote137 views1 answer
Run postgresql dump to csv
SQL
13 votes286 views4 answers
Sql joining 3 tables
SQL
0 vote227 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
-1 vote135 views3 answers
Check table exist postgresql
SQL
2 votes186 views3 answers
3 days back in sql server
SQL
1 vote136 views1 answer
Mysql server does not start mac
SQL