Programming - Code Revise

PL/SQL Program for Palindrome Number

PL/SQL Program for Palindrome Number Here you will learn pl/sql program for palindrome number using substr function in pl/sql programming. PL/SQL Program for Palindrome Number

DECLARE

input_number NUMBER := &Enter_Number; -- User will input the number

rev_number NUMBER := 0; -- variable to store reverse number

temp NUMBER; -- variable to store temp number

rem NUMBER; -- variable to store remainder number

BEGIN

temp := input_number;

-- reverse the digits of number

WHILE temp > 0 LOOP

remainder := MOD(temp, 10); -- Get the last digit

rev_number := (rev_number * 10) + rem; -- Build the reversed number

temp_number := FLOOR(temp_number / 10); -- Remove the last digit from the number

END LOOP;

-- Print input and reversed numbers

DBMS_OUTPUT.PUT_LINE('Input Number: ' || input_number);

DBMS_OUTPUT.PUT_LINE('Reversed Number: ' || rev_number);

-- Check if input number is equal to the reversed number

IF input_number = rev_number THEN

DBMS_OUTPUT.PUT_LINE('The number is a palindrome.');

ELSE

DBMS_OUTPUT.PUT_LINE('The number is not a palindrome.');

END IF;

END;

Output Enter_Number 1259 […]

PL/SQL Program for Palindrome Number Read More »

PL/SQL Program for Palindrome String

PL/SQL / By Lokesh Kumar

PL/SQL Program for Palindrome String Here you will learn pl/sql program for palindrome string using substr function in pl/sql programming. PL/SQL Program for Palindrome String

DECLARE

old_str VARCHAR2(50);

new_str VARCHAR2(50);

BEGIN

-- Prompt to get user input

DBMS_OUTPUT.PUT_LINE('Enter a string:');

-- store user input

old_str := '&input_string';

-- Loop to reverse the old string

FOR i IN REVERSE 1..LENGTH(old_str) LOOP

new_str := new_str || SUBSTR(old_str, i, 1);

END LOOP;

-- Print Old and New Reversed strings

DBMS_OUTPUT.PUT_LINE('Old String: ' || old_str);

DBMS_OUTPUT.PUT_LINE('New String: ' || new_str);

-- Check if the old string is equal to new string

IF old_str = new_str THEN

DBMS_OUTPUT.PUT_LINE('The string is a palindrome.');

ELSE

DBMS_OUTPUT.PUT_LINE('The string is not a palindrome.');

END IF;

END;

Output 1 Enter

PL/SQL Program for Palindrome String Read More »

PL/SQL Program to Reverse a String

PL/SQL / By Lokesh Kumar

PL/SQL Program to Reverse a String Here you will learn pl/sql program to reverse a string using substr function in pl/sql programming. PL/SQL Program to Reverse a String

DECLARE

old_str VARCHAR2(50) := 'Hello, PL/SQL';

new_str VARCHAR2(50);

BEGIN

FOR i IN REVERSE 1..LENGTH(old_str) LOOP

new_str := new_str || SUBSTR(old_str, i, 1);

END LOOP;

DBMS_OUTPUT.PUT_LINE('Old String: ' || old_str);

DBMS_OUTPUT.PUT_LINE('New String: ' || new_str);

END;

PL/SQL Program to Reverse a String Read More »

PL/SQL Program to print odd numbers using for loop

PL/SQL / By Lokesh Kumar

PL/SQL Program to print odd numbers using for loop Numbers that cannot be evenly divided by 2 are known as odd numbers. In this program, we will generate a list

PL/SQL Program to print odd numbers using for loop Read More »

PL/SQL Program for Fibonacci Series

PL/SQL / By Lokesh Kumar

PL/SQL Program for Fibonacci Series Here you will learn pl/sql program for fibonacci series. It is a series, in which each number is the sum of the last two previous

PL/SQL Program for Fibonacci Series Read More »

PL/SQL Program for Reversing a Number

PL/SQL / By Lokesh Kumar

PL/SQL Program for Reversing a Number Here you will learn pl/sql program for reversing a number. Reversing number means reverse the digits of a number. For example: Input Number =

PL/SQL Program for Reversing a Number Read More »

PL/SQL Program to Print Table of a Number

PL/SQL / By Lokesh Kumar

PL/SQL Program to Print Table of a Number In this program you will learn to create pl/sql program to print table of a number using for loop. PL/SQL Program

PL/SQL Program to Print Table of a Number Read More »

PL/SQL Program to Find Factorial of a Number

PL/SQL / By Lokesh Kumar

PL/SQL Program to Find Factorial of a Number Let’s do the PL/SQL Program to Find Factorial of a Number. Factorial are those number which can divide by one or itself

PL/SQL Program to Find Factorial of a Number Read More »

PL/SQL Program for even or odd number

PL/SQL / By Lokesh Kumar

PL/SQL Program for even or odd number Here you will get PL/SQL program for even or odd number checker. If a number is completely divisible by 2 is called even

PL/SQL Program for even or odd number Read More »

PL/SQL Program to Swap two Numbers

PL/SQL / By Lokesh Kumar

PL/SQL Program to Swap two Numbers Here you will know two different method of PL/SQL program to swap two numbers using a temporary variable and without using a temporary variable.

PL/SQL Program to Swap two Numbers Read More »