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 vote216 views1 answer
Open postgresql.conf in centos
SQL
57 votes323 views6 answers
Sql alter table
SQL
0 vote225 views1 answer
Limit in access query
SQL
6 votes194 views4 answers
Sqlite drop table
SQL
0 vote212 views3 answers
Postgresql allow remote connections
SQL
1 vote218 views2 answers
Mysql between
SQL
3 votes228 views2 answers
Mysql update row
SQL
5 votes190 views3 answers
How to remove unique key constraint in mysql
SQL
1 vote199 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote211 views1 answer
Cast as decimal postgresql
SQL