Oracle get table schema

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 TABLE_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All database Tables

Similar codes

0 vote368 views1 answer
Interview experience as a call?
SQL
7 votes358 views1 answer
Connect mysql docker
SQL
0 vote386 views1 answer
Data directory postgresql
SQL
1 vote367 views1 answer
Sql select all from one table and one column from another
SQL
9 votes347 views4 answers
Last mysql
SQL
0 vote383 views1 answer
Psotgres multiple values
SQL
3 votes345 views1 answer
Make a field auto_increment mysql
SQL
13 votes333 views3 answers
Uninstall mysql centos 7
SQL
0 vote358 views1 answer
Sql case sttement with set
SQL
0 vote364 views1 answer
Get current date data in mysql
SQL