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 vote156 views1 answer
Mysql group by derived column
SQL
1 vote149 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote162 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote157 views1 answer
Mysql range of dates overlap
SQL
4 votes201 views1 answer
Oracle change nls_date_format permanently
SQL
1 vote145 views1 answer
Right outer vs left outer join
SQL
3 votes159 views2 answers
Truncate table
SQL
0 vote177 views1 answer
Authentication modes in sql server
SQL
0 vote145 views1 answer
Sql where time stamp is in between
SQL
34 votes149 views5 answers
Oracle alter table add column
SQL