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 vote407 views1 answer
Move table to a different schema
SQL
4 votes363 views1 answer
Phone number sql
SQL
0 vote329 views1 answer
Sql runnignsum
SQL
0 vote397 views1 answer
How to retrive the today date sql
SQL
1 vote371 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote416 views1 answer
Download sql file of countries names
SQL
0 vote380 views1 answer
Mysql bash execute sql file
SQL
0 vote367 views1 answer
Postgres week number
SQL
13 votes363 views6 answers
Mysql update from select
SQL
2 votes369 views1 answer
Sql to char function with date
SQL