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 vote144 views1 answer
Mysql count with two joins
SQL
0 vote135 views1 answer
What is between operator
SQL
0 vote148 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote151 views1 answer
Replace \n sql
SQL
0 vote183 views1 answer
Sql server datetime
SQL
2 votes129 views2 answers
How to create an empty table from an existing table
SQL
1 vote152 views1 answer
Postgres see sequence current state
SQL
3 votes159 views2 answers
Sql not contains
SQL
0 vote149 views1 answer
Hex string sql becomes int64
SQL
0 vote131 views1 answer
Is numeric in sql
SQL