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

3 votes190 views2 answers
Sql server current date without time
SQL
0 vote289 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote233 views1 answer
Implode in sql query
SQL
6 votes182 views5 answers
Get current date sql
SQL
4 votes187 views4 answers
What is primary key
SQL
7 votes284 views1 answer
Oracle alter sequence restart start with
SQL
1 vote196 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
1 vote209 views1 answer
Tsql replace value in json
SQL
0 vote202 views1 answer
Sql change column in existing table
SQL
0 vote199 views1 answer
Sql select column names starting with
SQL