PL/SQL Program to Print Patterns

Here you will get plsql programs to print patterns of stars, numbers and alphabets. Pattern 1: * ** *** **** ***** declare n number:=5; i number; j number; begin for i in 1..n loop for j in 1..i loop dbms_output.put(‘*’); end loop; dbms_output.new_line; end loop; end; /

PL/SQL Program to Find Greatest of Three Numbers

Here you will get plsql program to find greatest of three numbers. 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 …

PL/SQL Program to Find Greatest of Three Numbers Read More »