목록Computer, IT, Programming (1)
hymn-book
(Oracle PL/SQL Sample) Function to output the vertical results into one row (horizontal)
I've created the function to print the vertical query results into one row horizontally with comma(,) seperated. As you can see above, the results of ENAME query are displayed in vertical way. I want to print the results like this : SMITH, ALLEN, WARD, ... create or replace function f_output_horizontal(v_sql in varchar2) return varchar2 is type c_refcur is ref cursor; c_sel c_refcur; v_ret varch..
Computer, IT, Programming
2022. 7. 22. 13:21