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 views2 answers
Install phoenix
SQL
2 votes140 views1 answer
Power query concatenate
SQL
0 vote79 views2 answers
Denormalization in sql
SQL
0 vote127 views1 answer
Closure in sql
SQL
0 vote123 views1 answer
Pip install mysqlclient error
SQL
0 vote136 views1 answer
How to locate pg_hba.conf file
SQL
0 vote132 views4 answers
Change schema in sql server
SQL
7 votes124 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote155 views2 answers
How to add amount between date in sql
SQL
0 vote123 views1 answer
Sum value by month sql
SQL