Here you will get pl/sql program to reverse a string. The substr() function returns a part of string. It has following syntax. substr(string, position, length); We will use this function to extract character by character from string in reverse order and concatenate it previous extracted character. || is used to concatenate string. In this way string …
Here you will get pl/sql program to check number is odd or even. A number is even if it is completely divisible by 2 otherwise it is odd. PL/SQL Program to Check Number is Odd or Even declare n number:=&n; begin if mod(n,2)=0 then dbms_output.put_line(‘number is even’); else dbms_output.put_line(‘number is odd’); end if; end; …
Here you will get pl/sql program for fibonacci series. It is a series in which next number is the sum of previous two numbers. PL/SQL Program for Fibonacci Series declare first number:=0; second number:=1; third number; n number:=&n; i number; begin dbms_output.put_line(‘Fibonacci series is:’); dbms_output.put_line(first); dbms_output.put_line(second); for i in 2..n loop third:=first+second; first:=second; second:=third; …
Here you will get pl/sql program for reverse of a number. For example: Number = 34589 Reverse of number = 98543 PL/SQL Program for Reverse of a Number declare n number; i number; rev number:=0; r number; begin n:=&n; while n>0 loop r:=mod(n,10); rev:=(rev*10)+r; n:=trunc(n/10); end loop; dbms_output.put_line(‘reverse is ‘||rev); end; / Output …
Here you will get pl/sql program to print table of a given number. You can ask your queries in comment section. declare n number; i number; begin n:=&n; for i in 1..10 loop dbms_output.put_line(n||’ x ‘||i||’ = ‘||n*i); end loop; end; / Output Enter value for n: 5 old 6: n:=&n; new 6: n:=5; …
Here you will get pl/sql program to find factorial of a number. We can calculate factorial of a number by multiplying it with all the numbers below it. For example factorial of 5 = 5 x 4 x 3 x 2 x 1 = 120. PL/SQL Program to Find Factorial of a Number declare …
Here you will get a pl/sql program for prime number. A number is a prime number if it is divisible by 1 or itself. For example 2, 3, 5, 7, etc are prime numbers. While numbers like 4, 6, 8, etc are not prime. PL/SQL Program for Prime Number declare n number; i number; …
Here you will get C/C++ program to find union of two arrays. For example: First array: {1, 3, 7, 9} Second array: {1, 4, 6} Union: {1, 3, 4, 7, 6, 9} C/C++ Program for Union of Two Arrays Union of Two Sorted Arrays If two arrays are sorted then their union can be …
