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

2 votes337 views3 answers
Postgresql reset auto increment
SQL
1 vote327 views1 answer
Oracle lock user
SQL
0 vote382 views1 answer
Combine 2 columns search query mysql
SQL
4 votes440 views3 answers
Mysql get column names from table
SQL
1 vote349 views1 answer
Oracle stop
SQL
19 votes340 views6 answers
Sql server drop table if exists
SQL
14 votes411 views1 answer
How to export db from mysql
SQL
19 votes378 views5 answers
Display table in sql
SQL
57 votes536 views6 answers
Sql alter table
SQL
4 votes290 views1 answer
And or sql order of operations
SQL