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

5 votes370 views3 answers
Mysql remove unique constraint
SQL
0 vote336 views1 answer
Insufficient memory to excute the sql query
SQL
3 votes370 views1 answer
Oracle drop user
SQL
4 votes350 views1 answer
Change nls_date_format
SQL
4 votes419 views1 answer
Mysql store ip address
SQL
0 vote348 views1 answer
Mssql view column data type
SQL
0 vote355 views1 answer
Heidisql check how much space a row
SQL
1 vote346 views1 answer
Oracle index partition
SQL
22 votes343 views4 answers
Show list of users in mysql
SQL
0 vote364 views1 answer
Not equal to blank in mysql
SQL