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 vote190 views1 answer
Psql check table fields
SQL
0 vote184 views1 answer
Get db connection detail from sql developer profile
SQL
14 votes174 views2 answers
How to auto increment in sql
SQL
9 votes178 views4 answers
Mysql show table fields
SQL
0 vote180 views1 answer
Mariadb cast null to 0
SQL
0 vote175 views1 answer
Postgre admin slow
SQL
0 vote192 views1 answer
Ver usuarios mysql
SQL
0 vote198 views1 answer
Comma seperated join mssql
SQL
1 vote189 views1 answer
Retrieve meaning
SQL
0 vote208 views1 answer
How to change the field size of an existing column
SQL