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

8 votes121 views2 answers
Sqlsrv default port
SQL
3 votes116 views2 answers
Postgresql remove not null constraint
SQL
8 votes114 views4 answers
Mysql update one table from another table multiple columns
SQL
11 votes130 views1 answer
Sql insert multiple rows from select
SQL
0 vote114 views1 answer
Sql string contains case sensitive
SQL
1 vote119 views1 answer
Psql connections
SQL
0 vote121 views1 answer
List in one column mysql
SQL
0 vote78 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote107 views1 answer
Insert data from stored procedure into table
SQL
0 vote114 views1 answer
Sql server list user permissions
SQL