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 vote372 views1 answer
Enable outgoing remote MySQL access
SQL
1 vote311 views1 answer
Oracle boolean to varchar
SQL
0 vote313 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote382 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote382 views1 answer
Oracle concat datetime
SQL
1 vote362 views1 answer
Oracle previous year
SQL
10 votes372 views2 answers
Oracle alter sequence nextval
SQL
1 vote349 views1 answer
Sql server datetime vs datetime2
SQL
13 votes330 views4 answers
Mysql get last row
SQL
4 votes365 views4 answers
What is primary key
SQL