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 vote315 views1 answer
Mysql f# examples
SQL
2 votes389 views3 answers
Sql delete duplicate
SQL
0 vote329 views1 answer
Sql server set complex constraints
SQL
0 vote324 views1 answer
Select even number id data from table
SQL
1 vote318 views1 answer
Sample in sql
SQL
2 votes341 views2 answers
Mysql add hours to time field
SQL
2 votes345 views1 answer
Mysql set value as null
SQL
2 votes326 views2 answers
Sql first character
SQL
2 votes342 views1 answer
Sql server current date minus 5 years
SQL
2 votes342 views2 answers
Storing timezones in postgres
SQL