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

1 vote233 views1 answer
Create new table from old table with data
SQL
1 vote101 views1 answer
Mssql string length
SQL
-1 vote179 views4 answers
Postgres between dates
SQL
0 vote165 views1 answer
Count in sql and diff
SQL
22 votes161 views3 answers
Remove all records from table mysql
SQL
0 vote154 views1 answer
Create database store
SQL
0 vote160 views1 answer
Consecutive numbers sql
SQL
4 votes153 views1 answer
Find tables with column name in sql
SQL
0 vote148 views1 answer
Kotlin sqlite delete row
SQL
2 votes161 views3 answers
Row number mysql
SQL