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 vote172 views3 answers
Mysql regex replace
SQL
0 vote167 views1 answer
Oracle string length
SQL
1 vote242 views3 answers
Showing all columns in an sqlite table
SQL
0 vote159 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote178 views2 answers
Call to undefined function mysql_query()
SQL
6 votes237 views1 answer
How to count number of rows in sql
SQL
0 vote167 views1 answer
Postgresql on conflict pair
SQL
0 vote157 views2 answers
Database owner can't create new tables postgres
SQL
0 vote164 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote169 views1 answer
Rabbitmq ui not working
SQL