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 vote213 views1 answer
Remove mysql from centos 7
SQL
1 vote234 views1 answer
Postgresql append array
SQL
-1 vote185 views1 answer
Round up and down sql
SQL
2 votes179 views1 answer
How to select first row of database sql
SQL
2 votes198 views2 answers
Mysql add hours to time field
SQL
5 votes196 views2 answers
Oracle rename table
SQL
2 votes180 views2 answers
Select multiple tables mysql
SQL
1 vote208 views1 answer
Hangfire clear all jobs
SQL
0 vote273 views1 answer
AddEntityFrameworkSqlite
SQL
2 votes193 views1 answer
Oracle to_char number format percentage
SQL