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 vote272 views1 answer
Oracle sql add column auto generated value
SQL
-1 vote262 views1 answer
Capitole toulouse
SQL
0 vote278 views1 answer
How to define a non primary composite key in sql
SQL
1 vote252 views1 answer
Sqlite create index
SQL
6 votes210 views2 answers
Generate c# class from sql server table
SQL
0 vote269 views1 answer
Insensitive case match sqlalchemy
SQL
1 vote255 views2 answers
Sql drop multiple columns if exists
SQL
0 vote263 views1 answer
Oracle show grants on table
SQL
0 vote269 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote242 views1 answer
Oracle lowercase
SQL