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 vote208 views1 answer
Hierarchal database table
SQL
5 votes186 views1 answer
Sqlite alter table add column
SQL
0 vote192 views1 answer
Oracle current timestamp insert statement
SQL
0 vote189 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote189 views1 answer
Mariadb current date plus 1 day
SQL
0 vote190 views1 answer
How to get inserted id in sql server
SQL
3 votes213 views1 answer
Oracle list privileges
SQL
0 vote228 views1 answer
How to make sure two tables have same exact data in sql
SQL
-1 vote197 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote210 views1 answer
Postgres get month name from date
SQL