본문 바로가기

hymn-book

검색하기
hymn-book
프로필사진 badminton

  • 분류 전체보기 (5)
    • Computer, IT, Programming (1)
    • Entertainment (2)
    • Travel (2)
Guestbook
Notice
Recent Posts
Recent Comments
Link
«   2026/05   »
일 월 화 수 목 금 토
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
Tags
  • Vietnam
  • BTS
  • DANANG
  • oracle
  • korean slang
more
관리 메뉴
  • 글쓰기
  • 방명록
  • RSS
  • 관리

목록oracle (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
Prev 1 Next

Blog is powered by AXZ / Designed by Tistory

티스토리툴바