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

7 votes295 views1 answer
Postgres base size
SQL
7 votes300 views1 answer
Safe mode mysql
SQL
4 votes311 views2 answers
Oracle unlock user
SQL
0 vote315 views4 answers
Postgresql between month
SQL
16 votes354 views1 answer
Sqlserver add column to table
SQL
4 votes294 views2 answers
Dbms_scheduler stop job
SQL
0 vote316 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote303 views1 answer
Match end of string regex sql
SQL
0 vote320 views1 answer
Postgresql check total storage
SQL
0 vote345 views1 answer
How to get button for every record from mysql
SQL