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 vote162 views1 answer
Mysql_union
SQL
0 vote160 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote181 views1 answer
Foreign key multiple columns
SQL
2 votes157 views1 answer
Mysql list users on ubuntu
SQL
0 vote181 views1 answer
Hex string sql becomes int64
SQL
16 votes219 views1 answer
Mysql mediumint max value
SQL
15 votes180 views5 answers
Show tables in oracle
SQL
0 vote184 views1 answer
Providername system.data. mysql
SQL
0 vote160 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote172 views1 answer
How to combine rows in sql server procedure
SQL