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 vote171 views1 answer
Difference between min and max date sql
SQL
7 votes161 views6 answers
Group_concat mysql
SQL
11 votes226 views2 answers
You are using safe update mode
SQL
2 votes199 views1 answer
Revokeprivileges mysql
SQL
0 vote176 views1 answer
Sql auto_increment syntax
SQL
-1 vote171 views1 answer
Mysql #1064 error
SQL
0 vote208 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote169 views1 answer
Concatenate columns in table
SQL
0 vote231 views1 answer
Varchar2 length in oracle
SQL
0 vote177 views1 answer
Mysql DDL
SQL