Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Unanswered: Column VALUES INTO Comma separated row.

    Hi,

    I have some column values:-

    employee_salary

    30000
    35000
    40000


    I need employee-salary in one row separated by comma by executing a sql query i.e

    dept1_salary

    30000, 40000, 50000

    Somebody told me there is a predefined function in Oracle for this. A preedefined function / SQL query would be very helpful.


    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2010
    Posts
    153
    Thanks for the info

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •