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

5 votes313 views1 answer
Oracle get foreign keys on table
SQL
0 vote314 views2 answers
Sql query for getting details by id
SQL
4 votes326 views1 answer
Oracle error line
SQL
0 vote307 views2 answers
Drop check constraint in ms sql
SQL
8 votes338 views1 answer
Oracle add datafile to tablespace
SQL
10 votes279 views2 answers
Django mysql
SQL
0 vote293 views1 answer
Access refused mysql xampp server
SQL
5 votes308 views1 answer
Oracle nls parameters
SQL
0 vote326 views1 answer
Mysql cli output to a file
SQL
0 vote330 views1 answer
Sql count * vs count 1
SQL