PL/SQL Program to Find Largest from Three Numbers

PL/SQL Program to Find Largest from Three Numbers: Declare a number; b number; c number; Begin a:=:a; b:=:b; c:=:c; dbms_output.put_line(‘Value…

add comment

PL/SQL Program to Find Area of Triangle

PL/SQL Program to Find Area of Triangle: declare base integer; height integer; area integer; begin base:=:base; height:=:height; dbms_output.put_line(‘Height = ‘||height);…

add comment

PL/SQL Program to Add Two Numbers

PL/SQL Program to Add Two Numbers: declare a number; b number; c number; begin a:=:a; b:=:b; c:=a+b; dbms_output.put_line(a||’ + ‘||b||’…

add comment

PL/SQL Program to Check Number is Prime or Not

PL/SQL Program to Check Number is Prime or Not: declare no number; i number; flag number; begin i:=2; flag:=1; no:=:no;…

add comment

PL/SQL Program to Accept Employee Number & Display Employee Details

PL/SQL Program to Accept Employee Number & Display Employee Details: declare no number; name varchar(15); salary number(10); deptname varchar(15); begin…

add comment

PL/SQL Program to Calculate Sum of Digit

PL/SQL Program to Calculate Sum of Digit: declare sod number; no number; len number; digit number; begin digit:=0; sod:=0; no:=:no;…

add comment

PL/SQL Program to Check Number is Armstrong Number or Not

PL/SQL Program to Check Number is Armstrong Number or Not: declare no number; arm number; len number; c number; begin…

add comment

PL/SQL Program to Check Number is Palindrome or Not

PL/SQL Program to Check Number is Palindrome or Not: declare no number(15); rev number(15); slen number(10); c char(1); Begin no:=:no;…

add comment

PL/SQL Program to Check String is Palindrome or Not

PL/SQL Program to Check String is Palindrome or Not: declare str varchar(15); rev varchar(15); slen number(10); c char(1); Begin str:=:str;…

add comment