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

6 votes189 views5 answers
Alter table oracle
SQL
0 vote186 views1 answer
Can we rollback deleted data in sql
SQL
0 vote250 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
4 votes189 views1 answer
Oracle user tables
SQL
5 votes192 views1 answer
Sysdate in oracle sql
SQL
1 vote196 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote228 views1 answer
Sql values that contains certain multiple ids
SQL
6 votes197 views1 answer
Oracle trigger after logon on schema
SQL
0 vote200 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote203 views1 answer
Decalre temp table sql
SQL