Skip to main content

Pl/SQl program Of Pallindrom using while Loop


declare
n integer;
revint integer;
rem integer;
orignal_num integer;

begin
  revint:=0;
  dbms_output.put_line('Enter a number');
  n:=&enter;
  orignal_num:= n;
  while n!= 0 loop
    rem:=MOD(n,10);
    revint:=revint*10 + rem;
    n:=n/10;
  end loop;
  if orignal_num=revint then
  dbms_output.put_line('Number is in pallindrom');
  else
  dbms_output.put_line('Number is not in pallindrom'); 
  end if;
end;

Comments

Popular posts from this blog

Pl/SQL program to find square of a user input number Using Function

declare   value1 number;   value2 number;   mytotal number;   function myfun(myval1 in number, myval2 in number) return number is     total number;   begin     total := myval1 ** myval2;     dbms_output.put_line(total);     return total;   end; begin   value1 :=&val1;   value2 := &val2;  mytotal:= myfun(value1, value2); end;