Will give GPU processing needs to be done to it.
Because CPU processing for a long time.
Code: SQL Plus Oracle - OraDB12c
CREATE OR REPLACE FUNCTION my_func
(p_digits IN VARCHAR2)
RETURN SYS.ODCIVARCHAR2LIST PIPELINED
AS
BEGIN
FOR v_rec IN
(SELECT DISTINCT REPLACE (SYS_CONNECT_BY_PATH (digit, '*'), '*', '') digits
FROM (SELECT LEVEL i, SUBSTR (p_digits, LEVEL, 1) digit
FROM DUAL
CONNECT BY LEVEL <= LENGTH (p_digits))
WHERE LEVEL = LENGTH (p_digits)
CONNECT BY NOCYCLE PRIOR i != i
ORDER BY digits)
LOOP
PIPE ROW (v_rec.digits);
END LOOP;
END my_func;
/
SELECT *
FROM TABLE (my_func (‘11111111111111111111111111111111222222222222222222222222222222223333333333333333333333333333333344444444444444444444444444444444555555555555555555555555555555556666666666666666666666666666666677777777777777777777777777777777888888888888888888888888888888889999999999999999999999999999999900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000’))
WHERE SUBSTR (COLUMN_VALUE, 2, 1) = ‘1’
/
please tell me.
i look forward to hearing from you.
Yours sincerely,
Thanks with best regards,
Navamin-Thailand.
navaminroad@gmail.com