Reverse a string in PL/SQL

Floyd's triangle in PL/SQL

Last Updated : 08 Jun, 2022

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Floyd's triangle is a right-angled triangular array of natural numbers. It is defined by filling the rows of the triangle with consecutive numbers, starting with a 1 in the top left corner. Given a range of number and the task is to form Floyd's triangle.

Examples:

Input: 1-29
Output:
 1
 2 3
 4 5 6
 7 8 9 10
 11 12 13 14 15
 16 17 18 19 20 21
 22 23 24 25 26 27 28

Below is the required implementation:

SQL

 
--floyd's triangle in PL/SQL 
DECLARE 
    --num, var_num variable declare 
    --num assign 1 
    num     NUMBER := 1; 
    var_num VARCHAR2(200); 
BEGIN 
    --loop  from 1 to 16 
    FOR i IN 1..16 LOOP 
        FOR j IN 1..i LOOP 
            var_num := var_num 
                       ||' ' 
                       ||num; 

            num := num + 1; 

            exit WHEN num = 16; 
        END LOOP; 

        --result print 
        dbms_output.Put_line(var_num); 

        exit WHEN num = 16; 

        var_num := NULL; 
    END LOOP; 
--end loop 
END; 
--end program

Output:

 1
 2 3
 4 5 6
 7 8 9 10
 11 12 13 14 15

Reverse a string in PL/SQL

jit_t

Improve

Article Tags :

Similar Reads

Reverse a string in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given a string, the task is to reverse a string using P

Count Possible Triangles

Given an unsorted array of positive integers, the task is to find the number of triangles that can be formed with three different array elements as three sides of triangles. For a triangle to be possible from 3 values as sides, the sum of the two values (or sides) must always be greater than the thi

Centered triangular number in PL/SQL

Prerequisite - PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given n and task is to find nth centered triangular num

PLSQL | TAN Function

The TAN function is an inbuilt function in PLSQL which is used to return the tangent of an input number. The tangent is a trigonometric function of an angle and here the input number is the angle expressed in the form of radians. 180 degree is equal to pi radian. Syntax: TAN( number ) Parameters Use

PLSQL | TANH Function

The PLSQL TANH function is used to return the hyperbolic tangent of a numeric value. The TANH function accepts one parameter which is the number whose hyperbolic tangent needs to be calculated. The TANH function returns a value of the numeric data type. This function takes as an argument any numeric

Blocks in PL/SQL

In PL/SQL, All statements are classified into units that is called Blocks. PL/SQL blocks can include variables, SQL statements, loops, constants, conditional statements and exception handling. Blocks can also build a function or a procedure or a package. The Declaration section: Code block start wit

Concatenation of strings in PL/SQL

Prerequisite - PL/SQL Introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations. Given two strings and the task is to concatenate them a

Maximum path sum in a triangle.

We have given numbers in form of a triangle, by starting at the top of the triangle and moving to adjacent numbers on the row below, find the maximum total from top to bottom. Examples : Input : 3 7 4 2 4 6 8 5 9 3 Output : 23 Explanation : 3 + 7 + 4 + 9 = 23 Input : 8 -4 4 2 2 6 1 1 1 1 Output : 19

PLSQL | REMAINDER Function

The REMAINDER function is an inbuilt function in PLSQL which is used to return the remainder of a divided by b. Syntax: REMAINDER(a, b) Parameters Used: This function accepts two parameters a and b which is used in calculating the remainder when a is divided by b. Return Value: This function returns

PLSQL | SIN Function

The PLSQL SIN function is used to return the sine of a numeric value. The SIN function accepts one parameter which is the number whose sine needs to be calculated. The SIN function returns a value of the numeric data type. This function takes as an argument any numeric data type as well as any non-n