SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure to get semicolon seperated values using select query

554406Jan 4 2007 — edited Jan 4 2007

I have got a requirement where I need to return a string with semi colon separated values. Input will also be a semi colon separated values I need to fetch data from tables and append those values into a string seperated by a semi colon.

Example
CREATE OR REPLACE
PROCEDURE GET_MAIL_IDS_FROM_ROLES
(roleIds IN varchar, mailIds OUT varchar)

select * from xxx where roles in (roleIds )

Thankyou

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2007

Added on Jan 4 2007

8 comments

972 views