DECLARE -- Declarative part (optional) -- Declarations of local types, variables, & subprograms BEGIN -- Executable part (required) -- Statements (which can use items declared in declarative part) DBMS_OUTPUT.PUT_LINE ('Hello World'); EXCEPTION -- Exception-handling part (optional) WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ('Error'); -- Exception handlers for exceptions raised in executable part] END;
Definition : Display the Sum of Two numbers
DECLARE -- Declarative part (optional) -- Declarations of local types, variables, & subprograms aa number(4); bb number(4); cc number(8); BEGIN -- Executable part (required) -- Statements (which can use items declared in declarative part) aa:=10; bb:=20; cc:= aa+bb; DBMS_OUTPUT.PUT_LINE('Sum is '||cc); EXCEPTION -- Exception-handling part (optional) WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ('Error'); -- Exception handlers for exceptions raised in executable part] END;
Now in above example change the following code and check the output.
bb:=0; cc:= aa/bb;