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 vote125 views1 answer
Is not numeric sql
SQL
3 votes69 views1 answer
Postgresql where current year
SQL
1 vote70 views1 answer
Strict in postgres SQL
SQL
0 vote101 views1 answer
Enable outgoing remote MySQL access
SQL
1 vote117 views1 answer
Install postgresql on raspberry pi
SQL
10 votes134 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote118 views1 answer
MySQL import data from large CSV file
SQL
7 votes120 views5 answers
Max 3 salary in sql
SQL
5 votes114 views1 answer
Sort order on two columns sql
SQL
0 vote102 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL