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

33 votes169 views6 answers
Change column name in mysql
SQL
0 vote171 views1 answer
See the structure of a table mysql
SQL
0 vote170 views1 answer
Mssql check if date is greater than today
SQL
23 votes171 views4 answers
How to show all users in mysql
SQL
-1 vote171 views1 answer
Can pandas fetch data from sql
SQL
3 votes171 views1 answer
Pl sql escape &
SQL
0 vote166 views1 answer
Openquery insert into linked server
SQL
2 votes195 views3 answers
Sql function
SQL
0 vote128 views1 answer
Flask_sqlalchemy install
SQL
6 votes177 views3 answers
Mysql server is not starting xampp
SQL