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 vote133 views1 answer
Mysql milliseconds
SQL
1 vote121 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
4 votes129 views1 answer
Change nls_date_format
SQL
19 votes142 views6 answers
Mysql if null
SQL
1 vote133 views1 answer
Postgresql contains
SQL
2 votes115 views1 answer
Codeigniter print last sql query
SQL
0 vote137 views1 answer
Oracle to_number
SQL
0 vote124 views2 answers
Sql drop view if exists
SQL
4 votes177 views1 answer
Postgresql list sequences
SQL
0 vote236 views1 answer
Sqlite woth cmake
SQL