PLSQL Block Structure/sample
Posted: Mon Mar 02, 2020 5:42 am
DECLARE
dummy NUMBER;
BEGIN
SELECT count(*) INTO dummy FROM dual;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
NULL;
END;
dummy NUMBER;
BEGIN
SELECT count(*) INTO dummy FROM dual;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
NULL;
END;