Answers for "how to write anonymous block in pl/sql"

SQL
2

anonymous block plsql

set serveroutput on;
DECLARE
   v_result NUMBER;
BEGIN
   v_result := 1 / 0;
   DBMS_OUTPUT.PUT_LINE( v_result );
EXCEPTION
   WHEN ZERO_DIVIDE THEN
      DBMS_OUTPUT.PUT_LINE( SQLERRM );
END;
Posted by: Guest on March-23-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language