| How can i Merge duplicate data in table (tabula format)? [message #290314] |
Fri, 28 December 2007 06:11  |
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  |
 |
Littlefoot
Messages: 21823
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
