Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> possible/impossible query?
I am looking for guidance on a problem that has perplexed me for the
past couple of months. Here is a description of what I have and what I
am trying to do:
Table: INFO (all the columns are varchar(1) – in this example) Col1 col2 col3 col4 col5 col6 col7
a b c d d e f a b c g h a b c i 1 2 3 4 5 6 7 1 2 3 a b c 1 2 3 d e z y x w v u t
The first 3 columns are not null and the remaining columns can be null. I am trying to develop a query and/or procedure/function/package to return this type result:
Col1 col2 col3 col4 col5 col6 col7
a b c d dgi eh f 1 2 3 4ad 5 6b 7ce z y x w v u t
If there are duplicates of the first 3 columns, the remaining rows with not null data will be concatenated together into one field. Eventually I would like to use this in Oracle Reports. If you are familiar with PVCS Dimensions, I am trying to emulate the behavior of thee unlimited text fields.
Can you please help me try to find a solution to this? Received on Fri Apr 19 2002 - 11:27:03 CDT