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

0 vote253 views1 answer
Vbscript create ADODB.Connection
SQL
2 votes275 views1 answer
Drop sequence
SQL
0 vote291 views1 answer
Sqlite insert or update
SQL
1 vote283 views1 answer
Postgresql pass array in function
SQL
0 vote271 views1 answer
Mariadb number format
SQL
0 vote265 views1 answer
Storing RGBA in mysql db
SQL
0 vote286 views1 answer
Change filed order in mysql
SQL
2 votes281 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
4 votes261 views1 answer
Mysql ip address
SQL
2 votes280 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL