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 vote174 views1 answer
Write a query to peint the pattern P(20)
SQL
14 votes206 views3 answers
Inner join sql oracle
SQL
0 vote164 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote161 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote183 views1 answer
Intellij idea add mysql connector
SQL
0 vote202 views1 answer
Sql date with year
SQL
0 vote139 views1 answer
Import csv to mysql
SQL
0 vote241 views1 answer
Get enginge db mysql
SQL
2 votes186 views2 answers
How to run postgresql in linux
SQL
1 vote183 views1 answer
Set statiscis on in ssms
SQL