Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION generate_series(
  i_start IN NUMBER,
  i_end   IN NUMBER,
  i_step  IN NUMBER DEFAULT 1
) RETURN SYS.ODCINUMBERLIST PIPELINED DETERMINISTIC
IS
  v_steps CONSTANT PLS_INTEGER := FLOOR((i_end - i_start)/i_step);
BEGIN
  FOR step_num IN 0 .. v_steps LOOP
    PIPE ROW (i_start + i_step * step_num);
  END LOOP;
END;
/
SELECT *
FROM   TABLE(generate_series(1,3,0.7));


COLUMN_VALUE


1

1.7

2.4


SELECT *
FROM   TABLE(generate_series(-5,-9,-0.4));


COLUMN_VALUE


-5

-5.4

-5.8

-6.2

-6.6

-7

-7.4

-7.8

-8.2

-8.6

-9


CREATE TABLE table_a (comp_name) AS
SELECT 'COGNIZANT' FROM DUAL UNION ALL
SELECT 'ABCD' FROM DUAL;
2 rows affected

SELECT comp_name,
       s.column_value
FROM   table_a
       CROSS JOIN TABLE(generate_series(1, LENGTH(comp_name), 2)) s


COMP_NAME
COLUMN_VALUE


COGNIZANT
1

COGNIZANT
3

COGNIZANT
5

COGNIZANT
7

COGNIZANT
9

ABCD
1

ABCD
3

COMP_NAME	COLUMN_VALUE
COGNIZANT	1
COGNIZANT	3
COGNIZANT	5
COGNIZANT	7
COGNIZANT	9
ABCD	1
ABCD	3