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

2 votes154 views2 answers
Python escape string for sql
SQL
1 vote129 views1 answer
Base nosql
SQL
0 vote134 views1 answer
Display first three characters sql
SQL
2 votes117 views2 answers
Get all columns from table sql
SQL
0 vote139 views1 answer
Setval postgres example table id
SQL
3 votes142 views2 answers
How to open postgresql in windows
SQL
0 vote138 views1 answer
Resullt all update knex mysql
SQL
1 vote132 views2 answers
Difference between in and between in sql
SQL
19 votes134 views6 answers
Sql create table
SQL
0 vote156 views1 answer
Mysql join only one column
SQL