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

0 vote115 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
1 vote130 views2 answers
Pad zero sql server
SQL
2 votes133 views2 answers
Mysql count rows returned
SQL
5 votes123 views2 answers
Sql number columns
SQL
10 votes124 views4 answers
Sql pagination
SQL
0 vote127 views1 answer
Set column in all row mysql
SQL
16 votes128 views3 answers
Delete row psql
SQL
1 vote128 views1 answer
Window function mysql
SQL
11 votes138 views4 answers
Update row in mysql
SQL
5 votes141 views1 answer
Mysql count newlines in field
SQL