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 vote356 views1 answer
Psql view enum values
SQL
0 vote336 views1 answer
Remove binlog mysql
SQL
1 vote322 views3 answers
Psql fatal database does not exist
SQL
0 vote361 views1 answer
Mysql update all record removing 2 hours from column
SQL
20 votes344 views1 answer
Sql change column types
SQL
50 votes408 views6 answers
Sql duplicate rows
SQL
0 vote374 views2 answers
Disallowed function mysql to_date()
SQL
0 vote350 views3 answers
Fetlife
SQL
0 vote335 views1 answer
Mysql grouping functions
SQL
-1 vote319 views1 answer
Io
SQL