Home » Developer & Programmer » Forms » Help needed to comma separate the values (Forms,6i,win xp)
Help needed to comma separate the values [message #412894] Mon, 13 July 2009 05:23 Go to next message
sharathmpatil
Messages: 38
Registered: February 2008
Location: Bangalore
Member

Hi all,

I have a requirement as follows.
Right now I have the display like this,

Department Employee

20 john
20 jacob

But I want the output to be like this,

Department Employee

20 john,jacob

If many employees are in the same department then i have separate their names with a comma and display in the front end form.

Thanks in advance.
Re: Help needed to comma separate the values [message #412897 is a reply to message #412894] Mon, 13 July 2009 05:39 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps the easiest way would be to create a view (search OraFAQ Forum and/or Google for "pivot") and base your form on a view which already has prepared data in a pivoting manner.
Previous Topic: Forms LOGON on opening every form
Next Topic: Providing username and password through forms for login to file server.
Goto Forum:
  


Current Time: Sun Dec 04 20:53:29 CST 2016

Total time taken to generate the page: 0.19293 seconds