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

1 vote360 views2 answers
Find nth highest salary of an employee
SQL
0 vote303 views1 answer
Expose db in virtualbox
SQL
1 vote351 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
10 votes325 views1 answer
How to import database in mysql by cmd
SQL
0 vote354 views1 answer
Call function sql oracle with output put line
SQL
0 vote386 views1 answer
Python sqlalchemy connection show server
SQL
0 vote352 views1 answer
Distinct data types in a table sql query
SQL
4 votes365 views3 answers
Sql drop database if exists
SQL
0 vote359 views1 answer
When mysql server would not work in xampp
SQL
2 votes352 views1 answer
Mysql virtual column
SQL