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

5 votes299 views3 answers
Truncate function in sql oracle
SQL
0 vote359 views1 answer
Check constraint is violated
SQL
1 vote337 views1 answer
Tsql update datetime
SQL
2 votes299 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote359 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote315 views1 answer
Show table details postgresql
SQL
-2 votes324 views1 answer
No module named '_sqlite3
SQL
0 vote320 views1 answer
Sqlite3 update select
SQL
5 votes332 views2 answers
Sql conn
SQL
10 votes319 views5 answers
Between keyword in sql
SQL