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 vote189 views2 answers
Sqlalchemy core in clause
SQL
0 vote200 views1 answer
Psql get table data types
SQL
1 vote203 views1 answer
Oracle duration between timestamps
SQL
0 vote190 views1 answer
Access refused mysql xampp server
SQL
0 vote241 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote212 views1 answer
Migration graphql
SQL
4 votes211 views3 answers
Mysql modify foreign key
SQL
0 vote215 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote232 views2 answers
Sql now - 1 day
SQL
0 vote209 views1 answer
Postgresql function ROUND
SQL