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
If column value is null then in mysql
SQL
0 vote131 views1 answer
Create schema sql server
SQL
0 vote141 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
12 votes156 views1 answer
Run mysql instance in docker
SQL
0 vote143 views1 answer
Nosql vs sql
SQL
0 vote144 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote142 views1 answer
How to reset the database value in SQL server
SQL
19 votes162 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote177 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote130 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL