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

3 votes205 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote160 views1 answer
Deleted table in sql trigger
SQL
0 vote159 views1 answer
Jooq finding lastest value in table
SQL
0 vote193 views1 answer
Sql select min row
SQL
0 vote197 views1 answer
How to check default value of column in sql server
SQL
0 vote218 views1 answer
Compare field sql server
SQL
0 vote200 views1 answer
Make a socket server to detect changes in mysql
SQL
2 votes207 views1 answer
How to make multiple keys as primary in bdms
SQL
9 votes195 views1 answer
Identity insert on sql server
SQL
2 votes200 views1 answer
Import large .sql files into lampp
SQL