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

46 votes229 views4 answers
Create column sql
SQL
0 vote255 views1 answer
Mssql unique key accept nulls
SQL
2 votes158 views1 answer
Drop all database tables oracle sql developer
SQL
13 votes162 views2 answers
Sql join
SQL
0 vote150 views1 answer
Mysql default timestamp value to be current timestamp
SQL
11 votes151 views3 answers
Sqlite3 create table from another table
SQL
1 vote163 views1 answer
Oracle sql first day of year
SQL
0 vote145 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote143 views1 answer
Zerar auto increment mysql
SQL
0 vote171 views1 answer
Replace divide by zero error with 0 in sql
SQL