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

11 votes138 views5 answers
Sql server reset identity
SQL
2 votes142 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote114 views2 answers
How to combine two sql queries in one result
SQL
-2 votes131 views1 answer
Modify column name in tsql
SQL
5 votes133 views1 answer
Get table columns from sql
SQL
1 vote154 views1 answer
Continue in sql
SQL
0 vote138 views1 answer
Mysql delete from where like
SQL
1 vote116 views1 answer
Oracle show execution plan
SQL
0 vote132 views2 answers
Postgresql get long running queries
SQL
0 vote132 views1 answer
How to print sql query
SQL