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 vote400 views1 answer
Datatables server side filter where clause
SQL
16 votes368 views1 answer
Mysql smallint range
SQL
0 vote396 views1 answer
Oracle exchange subpartition
SQL
0 vote395 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote345 views1 answer
Remove default constraint sql server
SQL
2 votes354 views1 answer
Import large .sql files into lampp
SQL
0 vote344 views1 answer
Sql server select ignore dupplicates
SQL
0 vote370 views2 answers
How to login to mysql as normal user in ubuntu
SQL
1 vote383 views1 answer
Deleting database in sql
SQL
2 votes404 views3 answers
Xampp mysql database not starting
SQL