Oracle user tables

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 TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All Tables

Similar codes

7 votes293 views2 answers
Mysql check db size
SQL
3 votes248 views1 answer
Difference sql vs mysql
SQL
3 votes263 views1 answer
Two selects in one query
SQL
0 vote257 views1 answer
Postgre admin slow
SQL
1 vote265 views2 answers
Mysql error 1215
SQL
1 vote277 views3 answers
Get all tables postgres
SQL
0 vote253 views1 answer
Oracle get running queries
SQL
5 votes268 views2 answers
Get columns number sql
SQL
0 vote282 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
4 votes308 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL