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 vote146 views1 answer
Sql query use select name inside where clause
SQL
0 vote156 views1 answer
Sql delete caracter list
SQL
0 vote138 views1 answer
Create table in dbms cmds
SQL
1 vote127 views1 answer
Group_concat max length mysql
SQL
0 vote141 views1 answer
How to join result table in mysql
SQL
13 votes126 views2 answers
Check if value is null mysql
SQL
2 votes134 views1 answer
Sql server conection string
SQL
0 vote189 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote140 views1 answer
Wordpress sql change site url
SQL
0 vote136 views7 answers
Les jointures sql server
SQL