Program to find largest of 2 numbers using PL/SQL
Code
DECLARE N NUMBER; M NUMBER; BEGIN N:=&N; --if : doesn't work use : M:=&M; IF N>M THEN DBMS_OUTPUT.PUT_LINE(''|| N ||' IS GREATER THAN '|| M ||''); ELSE DBMS_OUTPUT.PUT_LINE(''|| M ||' IS GREATER THAN '|| N ||''); END IF; END; /
output
7 IS GREATER THAN 5 Statement processed.