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

2 votes182 views1 answer
Removing view
SQL
0 vote174 views1 answer
Sql create table with datetime automatically
SQL
1 vote184 views1 answer
Mysql current time
SQL
22 votes205 views4 answers
Date format mysql
SQL
0 vote184 views1 answer
Postgres foreign key multiple columns
SQL
0 vote167 views1 answer
What is the essence of SQL?
SQL
5 votes174 views1 answer
Oracle ora-00054 causes
SQL
13 votes200 views4 answers
Command line mysql import
SQL
0 vote133 views1 answer
Mysql collation for all languages
SQL
0 vote175 views1 answer
Drop a field in psql django
SQL