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

1 vote358 views1 answer
Ora-01109 database not open in oracle 19c
SQL
25 votes347 views3 answers
How to use a database to see tables mysql
SQL
5 votes322 views1 answer
Sql check if date is between 2 dates
SQL
0 vote350 views1 answer
Mysql user set plugin
SQL
0 vote326 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote334 views1 answer
Returning with sqlalchemy
SQL
13 votes334 views2 answers
Get tables in database sql
SQL
-1 vote313 views1 answer
Adding a new table psql
SQL
0 vote306 views1 answer
Mysql update sum same table
SQL
1 vote333 views1 answer
Alter add syntax
SQL