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

1 vote171 views1 answer
Funzioni plsql
SQL
5 votes192 views6 answers
Sql foreign key
SQL
0 vote207 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote181 views1 answer
Sql if else in select
SQL
0 vote194 views1 answer
Is not numeric sql
SQL
0 vote182 views1 answer
Group by join columns per table
SQL
0 vote165 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote265 views1 answer
ORA-00942
SQL
0 vote196 views1 answer
Mysql get nth highest
SQL
2 votes207 views4 answers
How to find 2nd highest salary in mysql
SQL