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 votes222 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote316 views1 answer
Delet all record statment sql
SQL
0 vote247 views1 answer
Sql out file formate
SQL
0 vote241 views1 answer
How to find columns with null values in sql
SQL
1 vote233 views1 answer
Delete specific row in sql
SQL
-1 vote227 views5 answers
Online sql to linq generator
SQL
-2 votes255 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote233 views1 answer
Flexible search query delete table
SQL
2 votes179 views1 answer
Sql group by different columns
SQL
0 vote221 views1 answer
Sql server split string and insert into table select
SQL