I have been trying to covert my generating combination of numbers of SQL Plus Oracle into Cuda generating combination of numbers
program
I have an intense number crunching application which I need converted into CUDA to maximize speed. I will also need you to add a couple of features to the program. I need someone with years of CUDA experience.
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 (‘1111111111111111111111111111111122222222222222222222222222222222
3333333333333333333333333333333344444444444444444444444444444444
5555555555555555555555555555555566666666666666666666666666666666
7777777777777777777777777777777788888888888888888888888888888888
9999999999999999999999999999999900000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000’))
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