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

15 votes244 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote98 views1 answer
If null don't update
SQL
92 votes295 views6 answers
Substring
SQL
0 vote97 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote96 views1 answer
How to print out column name differently in mysql
SQL
0 vote96 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
1 vote58 views1 answer
Mssql string length
SQL
1 vote92 views1 answer
Create table tablename as select * from tablename
SQL
1 vote121 views1 answer
Check current sequence value postgres
SQL
0 vote107 views1 answer
Create sql table from script inline primary key constraint
SQL