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

6 votes195 views5 answers
Mysql get last insert id
SQL
-1 vote250 views1 answer
Partial search in sql
SQL
1 vote204 views1 answer
Get create table query existing table mysql
SQL
0 vote212 views2 answers
Import .sql into postgres db command
SQL
11 votes184 views2 answers
Having clause
SQL
1 vote204 views2 answers
Postgres copy table from one schema to another
SQL
0 vote195 views1 answer
Get all employees if name ends with in sql
SQL
0 vote235 views1 answer
SQL-Arten
SQL
33 votes197 views6 answers
Sql delete
SQL
0 vote199 views2 answers
How to check if a column exists in a SQL Server table?
SQL