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.

Report message to a moderator

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: 21818
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.

Report message to a moderator

Previous Topic: Forms LOGON on opening every form
Next Topic: Providing username and password through forms for login to file server.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:48:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.