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 vote286 views1 answer
Mysql monthname
SQL
0 vote316 views2 answers
Mysql calcular idade
SQL
0 vote295 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote305 views2 answers
Advantages of stored procedures sql
SQL
3 votes311 views2 answers
How to open postgresql in windows
SQL
0 vote295 views1 answer
Sql server express download
SQL
8 votes279 views1 answer
Oracle find text in functions
SQL
1 vote319 views1 answer
Connect to mysql database ubuntu
SQL
9 votes283 views4 answers
Add primary key to existing table sql
SQL
0 vote293 views1 answer
Hw to delete a procedure in pl sql
SQL