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 vote94 views1 answer
Sql only five first row
SQL
0 vote104 views1 answer
Sql orcale i forgot what my name & password was
SQL
9 votes102 views3 answers
Mysql show table column full description
SQL
0 vote99 views2 answers
Find Overlapping sql
SQL
0 vote111 views1 answer
Postgresql auto increment not working
SQL
0 vote111 views1 answer
Mysql sum with group by
SQL
0 vote213 views1 answer
Sqlite display data in separated columns
SQL
0 vote106 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote119 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote117 views1 answer
Trigger stock phpmyadmin
SQL