Check if table exists oracle

SELECT * FROM USER_TABLES WHERE TABLE_NAME = 'my_table';
-- Tables from schemes you can access
SELECT * FROM ALL_TABLES WHERE OWNER = 'scheme_name' TABLE_NAME = 'my_table';
-- Tables from schemes you can access
SELECT * FROM DBA_TABLES WHERE OWNER = 'scheme_name' TABLE_NAME = 'my_table';

Similar codes

0 vote213 views2 answers
Sql 2 way of select unique
SQL
-1 vote242 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote211 views1 answer
Datatables server side filter where clause
SQL
0 vote255 views1 answer
Mysql enter ubuntu
SQL
1 vote199 views1 answer
Sql delete all values in a column
SQL
0 vote206 views1 answer
Dapper run sql script with parameters
SQL
37 votes247 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote206 views2 answers
How to count codition
SQL
1 vote232 views1 answer
Mysql search like order by best match
SQL
0 vote206 views2 answers
Py sqlite if entry exists
SQL