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

6 votes250 views1 answer
To count number of rows in SQL table
SQL
1 vote258 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote264 views1 answer
Get rows from 1 table with other table empty mysql
SQL
1 vote295 views1 answer
Create new table from old table
SQL
2 votes264 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
3 votes257 views1 answer
Dbms_scheduler drop_job
SQL
1 vote245 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote248 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes248 views1 answer
Query to find table size in oracle 12c
SQL
0 vote244 views1 answer
Declarative base sqlalchemy
SQL