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 vote378 views2 answers
Pl sql auto increment
SQL
6 votes341 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote321 views1 answer
Find largest table in mysql database
SQL
4 votes321 views1 answer
Select first and last row sql
SQL
3 votes341 views1 answer
How to find names includes in sql
SQL
5 votes333 views2 answers
Oracle list columns schema
SQL
0 vote346 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote359 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote338 views1 answer
Postgres type equivalent to timespan c#
SQL
1 vote331 views1 answer
Spring postgresql reset auto increment to 0
SQL