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';check if table exists oracle
BEGIN
SELECT COUNT(*)
INTO l_cnt
FROM dba_tables
WHERE owner = <<table owner>>
AND table_name = <<table name>>;
IF( l_cnt > 0 )
THEN
EXECUTE IMMEDIATE 'SELECT col1 FROM x'
BULK COLLECT INTO some_collection;
ELSE
SELECT 'table X does not exist'
INTO some_variable
FROM dual;
END IF;
END;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
