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

13 votes249 views2 answers
Sql online compiler
SQL
0 vote240 views1 answer
Create table with float datatype in sql server
SQL
0 vote182 views1 answer
Mysql collation for all languages
SQL
6 votes254 views2 answers
Mysql execute file
SQL
0 vote247 views1 answer
Sql developer search all packages for text
SQL
1 vote259 views1 answer
Tsql replace value in json
SQL
8 votes285 views3 answers
Find table for column name in sql
SQL
3 votes253 views2 answers
Update part of a string in mysql
SQL
0 vote235 views1 answer
Postgres drop type
SQL
0 vote285 views1 answer
Generate a random otp in sql server
SQL