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

4 votes194 views3 answers
Employee name starting with in sql
SQL
1 vote186 views1 answer
Python escape mysql
SQL
1 vote163 views2 answers
Delete auto increment mysql
SQL
3 votes196 views2 answers
Mysql config user password
SQL
-1 vote177 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote191 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote278 views1 answer
Sql server system messeges
SQL
2 votes211 views1 answer
Sql server find columns list in tables
SQL
0 vote200 views2 answers
Advantages of stored procedures sql
SQL
94 votes416 views4 answers
Create database postgres
SQL