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 vote216 views1 answer
Get date from timestamp in mysql
SQL
0 vote257 views1 answer
Pl sql join 3 tables
SQL
0 vote219 views1 answer
Get last date join sql
SQL
4 votes214 views2 answers
Error loading MySQLdb module.
SQL
0 vote206 views1 answer
Mod in sql
SQL
0 vote226 views1 answer
How to move a columns location in mysql
SQL
1 vote211 views1 answer
Sql eliminare un record
SQL
25 votes214 views5 answers
Uninstall mysql ubuntu
SQL
0 vote203 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote192 views1 answer
Clone table structure mysql
SQL