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 vote139 views1 answer
Mysql Error Code: 1005
SQL
9 votes142 views3 answers
Mysql get last id
SQL
0 vote141 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
1 vote143 views1 answer
Mysql best tutorial for beginners
SQL
0 vote165 views2 answers
Php convert dbf to mysql
SQL
0 vote146 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote162 views1 answer
How to set up an anonymous function to variable in swift
SQL
6 votes177 views2 answers
What is non relational database
SQL
11 votes142 views2 answers
Oracle all source
SQL
12 votes177 views6 answers
Distinct in sql server
SQL