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

58 votes546 views6 answers
Create new user in postgres
SQL
1 vote272 views1 answer
Oracle update with sequence
SQL
1 vote256 views1 answer
Reutrn string after character sql
SQL
-1 vote274 views1 answer
Sql add column bit
SQL
1 vote313 views1 answer
Oracle see column type
SQL
0 vote283 views2 answers
Reseed sql identity
SQL
0 vote274 views3 answers
Sql delete all except
SQL
0 vote271 views1 answer
Compression of dabatase mysqldumo
SQL
57 votes471 views5 answers
How to create a new user in postgresql
SQL
4 votes289 views2 answers
Linq join
SQL