This discussion is archived
0 Replies Latest reply: Sep 5, 2009 9:30 PM by 721043 RSS

Need help for Oracle Stored proc, Need to read multi values???? Urgent Thks

721043 Newbie
Currently Being Moderated
Hi,

I have to write a stored proc and I am new to it.

The requirement is:

1. There is a user table with userid as PK

2. For each userid we have a role table with role id.

One userid can have mutiple roles (role id).

I have to return a comma separated values of roles for each userid along with user details.
Pls suggest some better way?

Thnks for all your help.

With Regrds

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points