PL/SQL Program to Accept Number and Print in Alphabet

PL/SQL Program to Accept Number and Print in Alphabet: declare no number; no_to_word varchar2(100); str varchar2(100); len number; c number;…

add comment

PL/SQL Program to Find GCD of Two Numbers

PL/SQL Program to Find GCD of Two Numbers : declare no1 number; no2 number; temp number; begin no1:=:no1; no2:=:no2; while…

2 comments

PL/SQL Program to Find Square of Number

PL/SQL Program to Find Square of Number: declare no number; sqr number; begin no:=:no; sqr:=no*no; dbms_output.put_line(‘Given Number is ‘||no); dbms_output.put_line(‘…

add comment

PL/SQL Program to Find Length of String

PL/SQL Program to Find Length of String: declare str varchar2(20); len number; begin str:=:str; len:=Length(str); dbms_output.put_line(‘Given String is ‘||str); dbms_output.put_line(‘…

add comment

PL/SQL Program to Find Area and Perimeter of Rectangle

PL/SQL Program to Find Area and Perimeter of Rectangle : declare length number; width number; area number; perimeter number; begin…

add comment

PL/SQL Program to Find Area of Circle

PL/SQL Program to Find Area of Circle: declare radius float; area float; begin radius:=:radius; area:=3.14*radius*radius; dbms_output.put_line(‘The area of circle is…

add comment

PL/SQL Program to Swap Two Number Without Using Third Variable

PL/SQL Program to Swap Two Number Without Using Third Variable: declare a number; b number; begin a:=:a; b:=:b; dbms_output.put_line(‘Value of…

add comment

PL/SQL Program to Swap Two Strings

PL/SQL Program to Swap Two Strings: declare a varchar2(10); b varchar2(10); begin a:=:a; b:=:b; dbms_output.put_line(‘Value of a is ‘||a); dbms_output.put_line(‘Value…

add comment

PL/SQL Program to Reverse the given String

PL/SQL Program to Reverse the given String: declare str1 varchar2(30); len number; str2 varchar2(30); i number; begin str1:=:str1; len:=length(str1); for…

add comment

PL/SQL Program to Display Multiplication Table

PL/SQL Program to Display Multiplication Table: declare i number; no number; begin no:=:no; for i in 1..10 loop dbms_output.put_line( no…

add comment