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 vote324 views1 answer
Python get backup of sql
SQL
1 vote269 views3 answers
How to filter repeated same result using sql query
SQL
14 votes268 views3 answers
Trim sql
SQL
0 vote249 views1 answer
Bigquery declare
SQL
0 vote287 views1 answer
Modifier une valeur sql
SQL
1 vote268 views1 answer
Oracle enable job
SQL
0 vote266 views1 answer
Mysql wait_timeout
SQL
1 vote259 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote253 views1 answer
Cast for print sql
SQL
1 vote245 views1 answer
Display total number of tables in mysql
SQL