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: 21151
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: ORA-12514: TNS: Listner does not currently know of service requested in connector descriptor
Next Topic: Maximize explorer at runtime
Goto Forum:
  


Current Time: Wed Aug 23 14:40:45 CDT 2017

Total time taken to generate the page: 0.14254 seconds