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 vote125 views1 answer
Write sql query to show the details start from digit
SQL
0 vote130 views2 answers
How to count codition
SQL
1 vote146 views1 answer
Mysql dump specific tables
SQL
0 vote112 views3 answers
Sql count condition
SQL
1 vote120 views1 answer
Mysql query where in select
SQL
0 vote138 views1 answer
Sql query to find duplicate email address
SQL
11 votes131 views4 answers
Update row in mysql
SQL
8 votes122 views1 answer
Ltrim sql
SQL
61 votes303 views6 answers
Mysql add column
SQL
2 votes118 views1 answer
Convert series number to date in sql
SQL