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 vote136 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote142 views1 answer
Mysql changer nom table
SQL
0 vote135 views1 answer
SqlFunction does not exist
SQL
10 votes121 views3 answers
Sql limit results
SQL
0 vote149 views1 answer
Add mysql database to power bi web
SQL
0 vote143 views2 answers
Sqlalchemy default value for column
SQL
18 votes137 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
1 vote129 views1 answer
Get table column names sql ssms
SQL
2 votes135 views1 answer
How to insert string variable into sqlite database
SQL
0 vote140 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL