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 vote166 views1 answer
Sql server delete records with specific date
SQL
9 votes167 views6 answers
Sql add column with default value
SQL
0 vote182 views1 answer
Mysql cli output to a file
SQL
0 vote179 views1 answer
Mysql min value row
SQL
0 vote170 views1 answer
Oracle current session details
SQL
-1 vote191 views1 answer
Mysql select count if contains
SQL
0 vote164 views1 answer
Sql get month and year from date
SQL
0 vote190 views1 answer
Compare subqueries oracle
SQL
2 votes167 views2 answers
Install sqlalchemy
SQL
0 vote167 views2 answers
Soql last year
SQL