Here you will get plsql program to find greatest of three numbers.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
declare a number:=10; b number:=12; c number:=5; begin dbms_output.put_line('a='||a||' b='||b||' c='||c); if a>b AND a>c then dbms_output.put_line('a is greatest'); else if b>a AND b>c then dbms_output.put_line('b is greatest'); else dbms_output.put_line('c is greatest'); end if; end if; end; / |
Output
a=10 b=12 c=5
b is greatest
how to see the output
at begining of the code write “set serveroutput on”
Enter. /
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘on
declare
a_number:=10;
b_number:=12;
c_number:=5;
begin
‘dbms_output.put_l’ at line 1