Answers for "check table exists or not in oracle"

SQL
0

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';
Posted by: Guest on April-17-2021

Code answers related to "check table exists or not in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language