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 vote269 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
22 votes237 views4 answers
Mysql date_format
SQL
4 votes221 views2 answers
DB::transaction
SQL
2 votes218 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
4 votes286 views4 answers
Check constraint in ms sql
SQL
0 vote249 views1 answer
Postgresql create table many-to-many
SQL
0 vote280 views2 answers
Fanyi
SQL
41 votes260 views6 answers
Alter table add column in SQL Server
SQL
0 vote256 views1 answer
Min:sec datediff mssql
SQL
9 votes204 views2 answers
Cmd to rename a collumn name in sql
SQL