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 vote225 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote222 views1 answer
How to insert same table data using mysql query
SQL
0 vote234 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote242 views2 answers
Nested query
SQL
3 votes308 views1 answer
Apex call duration
SQL
1 vote261 views1 answer
Mysql update inner
SQL
0 vote242 views1 answer
Neo4j command to run script file
SQL
0 vote225 views1 answer
Oracle job session
SQL
1 vote256 views1 answer
Postgres see sequence current state
SQL
51 votes495 views6 answers
Installing mysql on ubuntu
SQL