Home » Developer & Programmer » Forms » How can i Merge duplicate data in table (tabula format)?
How can i Merge duplicate data in table (tabula format)? [message #290314] Fri, 28 December 2007 06:11 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear Experts,

How can i present my data in a forms Table (Tabular Format)
by merged of the duplicate data as below:

My Working Environment:
OS: Windows 2003 Server, XP professional
DBS: Oracle 10g
Developer: 10g

My problem:
DEPTNO    NAME          SAL
10       SMITH          3000
20       JOHN           4000
20       BLAKE          7000
30       WILLIAM        4500

My required Solution:
DEPTNO        NAME        SAL
10            SMITH       3000
20            JOHN        4000
              BLAKE       7000
30            WILLIAM     4500

Can any one help me please?

Kamal Hossain
Dhaka, Bangladesh

[EDITED by LF: added [code] tags to improve readability]

[Updated on: Fri, 28 December 2007 06:58] by Moderator

Report message to a moderator

Re: How can i Merge duplicate data in table (tabula format)? [message #290337 is a reply to message #290314] Fri, 28 December 2007 07:04 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Your requirement doesn't fit into Forms playground. You could do that in one of reporting tools (Reports Builder, or even SQL*Plus by using the BREAK command), but in Forms ... it just doesn't make sense here.

P.S. I forgot to mention that you might create a master-detail relationship between "departments" and "employees who work in these departments", but that wouldn't be strictly what you are looking for.

[Updated on: Fri, 28 December 2007 07:05]

Report message to a moderator

Previous Topic: Item Type property of an item
Next Topic: getting message for every record while pressing down arrow
Goto Forum:
  


Current Time: Sat Dec 10 03:32:09 CST 2016

Total time taken to generate the page: 0.05005 seconds