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 vote305 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote321 views1 answer
Php mysqli install
SQL
0 vote317 views1 answer
Sql where part of string match
SQL
0 vote305 views1 answer
Running query in redshift
SQL
0 vote297 views1 answer
Call function in query sql server
SQL
4 votes284 views1 answer
Oracle show error line number
SQL
0 vote324 views1 answer
Sqlalchemy empty table
SQL
9 votes305 views4 answers
How to create new user and database postgresql in ubuntu
SQL
25 votes327 views3 answers
How to use a database to see tables mysql
SQL
0 vote341 views1 answer
PGSQL dynamic table name
SQL