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 vote275 views1 answer
Use between operator in mysql
SQL
0 vote291 views1 answer
Clear query cache sql server
SQL
9 votes295 views3 answers
Show table columns mysql command line
SQL
0 vote266 views1 answer
How to get n result in sql
SQL
6 votes288 views5 answers
Alter table oracle
SQL
1 vote291 views2 answers
Oracle 18c xe ORA-65096
SQL
6 votes291 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote280 views1 answer
Oracle gather table statistics
SQL
0 vote295 views1 answer
Into operator in sql
SQL
3 votes305 views1 answer
Two select sql
SQL