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

28 votes144 views6 answers
Distinct sql
SQL
0 vote195 views1 answer
How to Remove milliseconds from Date time
SQL
1 vote211 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
2 votes192 views1 answer
Mysql sysdate - 1 day
SQL
0 vote215 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote187 views1 answer
Sql create text column limited values
SQL
0 vote211 views2 answers
How to count codition
SQL
0 vote146 views1 answer
Finish transaction sql
SQL
1 vote177 views1 answer
Mysqli connect
SQL
1 vote206 views1 answer
Sqlalchemy order by descending
SQL