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

1 vote215 views4 answers
Postgres extract date from timestamp
SQL
1 vote192 views1 answer
Mysql get last insert id
SQL
0 vote276 views1 answer
Selecting specific day in colum sql
SQL
0 vote206 views1 answer
Ffeathers express mysql application users login
SQL
0 vote230 views1 answer
Mysql récupérer le code création de vue
SQL
-1 vote193 views10 answers
Delete Query in SQL Server
SQL
1 vote207 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote207 views1 answer
Oracle get running queries
SQL
0 vote254 views1 answer
Add super privilege mysql
SQL
0 vote220 views1 answer
Mysql date minus 1 day
SQL