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 vote153 views1 answer
How to avoid duplicate records in sqlite
SQL
10 votes135 views1 answer
Oracle dependency
SQL
1 vote169 views3 answers
Connection string mysql
SQL
9 votes173 views3 answers
Sequence postgresql
SQL
0 vote145 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote136 views1 answer
Call procedure in wordpress
SQL
1 vote158 views1 answer
Sql padd let with zeros
SQL
0 vote150 views1 answer
Mysql date time string format python
SQL
0 vote159 views1 answer
Check for directory in bash
SQL
3 votes135 views1 answer
Sql timestamp to date
SQL