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 vote143 views1 answer
What is metadata in sql
SQL
2 votes166 views1 answer
Laravel sql String
SQL
0 vote265 views1 answer
Android sqlite add column if not exists
SQL
13 votes156 views5 answers
Sql default
SQL
0 vote174 views1 answer
C# sql transaction multiple connections
SQL
2 votes151 views1 answer
Mysql time ago difference
SQL
0 vote145 views1 answer
Sql contains vs like
SQL
3 votes150 views1 answer
Sql cast to integer
SQL
4 votes175 views3 answers
Postgres drop all tables
SQL
4 votes136 views1 answer
Id primary key auto generated
SQL