I am trying to convert the stored procedure from oracle to TD, below is the cursor used in Stored procedure
Oracle's CONNECT BY is proprietary syntax, usually rewritten using WITH RECURSIVE, but I don't know if you can do that in a cursor.
Looks like splitting data into multiple rows, there's a high probability that this can be done using REGEXP_SPLIT_TO_TABLE. But what's the meaning of last conditon based on dbms_random?
Can you add some actual data and what's returned?
Its is the stored procedure which been already exisiting in Oracle database, below is the cursor declaration in Oracle stored procedure
CURSOR pnr_od_cur IS