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

1 vote261 views1 answer
Update and replace mysql
SQL
1 vote221 views1 answer
Ms sql how to see active job current run time
SQL
1 vote276 views1 answer
Sql pick random row
SQL
0 vote272 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
5 votes270 views1 answer
Ora-00054 find lock
SQL
0 vote254 views2 answers
Plan d'exécution requete oracle autotracer
SQL
22 votes340 views1 answer
Mysql workbench
SQL
0 vote286 views1 answer
Alter table add check constraint oracle
SQL
0 vote263 views1 answer
Merge clause with inner join
SQL
2 votes270 views6 answers
In operator in sql
SQL