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 vote108 views1 answer
Mysql vs sql server performance benchmark
SQL
1 vote122 views1 answer
Get table column names sql ssms
SQL
0 vote105 views1 answer
Sql select all tables from database change url
SQL
0 vote108 views1 answer
Create domain sql
SQL
0 vote112 views1 answer
Drop domain postgresql
SQL
0 vote124 views1 answer
Mysql change timestamp on update
SQL
-1 vote117 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
41 votes133 views6 answers
Alter table add column in SQL Server
SQL
0 vote117 views1 answer
Backup a table in sql
SQL
6 votes100 views1 answer
Phpmyadmin reset root password
SQL