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 vote147 views1 answer
Match end of string regex sql
SQL
0 vote177 views1 answer
Sp help text in postgresql
SQL
8 votes149 views1 answer
Oracle all_source package body
SQL
2 votes133 views1 answer
Wait delay in sql server
SQL
10 votes156 views2 answers
Mysql drop database if exists
SQL
1 vote145 views1 answer
Sql drop with dependencies
SQL
1 vote187 views2 answers
Sql split string by space
SQL
0 vote147 views1 answer
Turn on foreign keys check mysql
SQL
11 votes205 views3 answers
Pl sql example
SQL
-1 vote142 views1 answer
Pl/sql how to delete a trigger
SQL