How to return a dynamic result set in Oracle function?

Assuming the function compiles, try: SELECT * FROM TABLE(strtokenizer('a,b,c',',')); Reference: Returning Rows Through a Table Function in Oracle The function needs to be corrected - use: CREATE OR REPLACE FUNCTION StrTokenizer (string IN VARCHAR2, delimiter IN VARCHAR2) RETURN key_value_table AS v_ret key_value_table BEGIN SELECT CAST(MULTISET(SELECT LEVEL k, SUBSTR(STRING_TO_TOKENIZE, DECODE(LEVEL, 1, 1, INSTR(STRING_TO_TOKENIZE, DELIMITER, 1, LEVEL-1)+1), INSTR(STRING_TO_TOKENIZE, DELIMITER, 1, LEVEL) - DECODE( LEVEL, 1, 1, INSTR(STRING_TO_TOKENIZE, DELIMITER, 1, LEVEL-1)+1)) v FROM (SELECT string || delimiter AS STRING_TO_TOKENIZE , delimiter AS DELIMITER FROM DUAL) CONNECT BY INSTR(STRING_TO_TOKENIZE, DELIMITER, 1, LEVEL)>0 ORDER BY level ASC) AS key_value_table) INTO v_ret FROM DUAL; RETURN v_ret; END.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions