RE: A How-To

Sorry everyone.

cppr:laurab> DESC deltek.GENL_UDEF
 Name                                                              Null?
Type
 ----------------------------------- -------- ------------------------
 GENL_ID                             NOT NULL VARCHAR2(30)
 GENL1_ID                            NOT NULL NUMBER(10)
 S_TABLE_ID                          NOT NULL VARCHAR2(20)
 UDEF_LBL_KEY                        NOT NULL NUMBER(10)
 UDEF_TXT                                     VARCHAR2(30)
 UDEF_ID                                      VARCHAR2(20)
 UDEF_DT                                      DATE
 UDEF_AMT                                     NUMBER(14,4)
 MODIFIED_BY                                  NOT NULL VARCHAR2(20)
 TIME_STAMP                                   NOT NULL DATE
 ROWVERSION                                   NUMBER(10)
 COMPANY_ID                          NOT NULL VARCHAR2(10)

Ok, this is the table.  The sample data is as follows:

GENL_ID                          GENL1_ID S_TABLE_ID
UDEF_LBL_KEY UDEF_TXT
------------------------------ ---------- --------------------
------------ ------------------------
UDEF_ID              UDEF_DT     UDEF_AMT MODIFIED_BY          TIME_STAM
ROWVERSION COMPANY_ID
-------------------- --------- ---------- -------------------- ---------
---------- ----------
012228                                  0 PR
9
                                    21.52 PRCONSULT            19-MAY-05
0 1

012228                                  0 PR
31 1430
                                          PRCONSULT            19-MAY-05
0 1

012228                                  0 PR
32 0D
                                          PRCONSULT            19-MAY-05
0 1

012228                                  0 PR
28 014257
                                          PRCONSULT            19-MAY-05
0 1

012228                                  0 PR
30
40                                        PRCONSULT            19-MAY-05
0 1

012228                                  0 PR
19
2ND                                       PRCONSULT            19-MAY-05
0 1

012229                                  0 PR
9
                                    20.43 PRCONSULT            19-MAY-05
0 1

012229                                  0 PR
19
1ST                                       PRCONSULT            19-MAY-05
0 1

012229                                  0 PR
28 014348
                                          PRCONSULT            19-MAY-05
0 1

012229                                  0 PR
32 4G
                                          PRCONSULT            19-MAY-05
0 1

012229                                  0 PR
31 600
                                          PRCONSULT            19-MAY-05
0 1


Each record represents a certain piece of data, i.e. UDEF_LBL_KEY 31
represent Start Time; UDEF_LBL_KEY 32 represents Overtime Project, etc.

So when I select from the table I get a row for each record.  What I
want is one row which each of the records listed as a column

Empl Id Start Time         Overtime Proj =20
012228     1430          0D
012228     600         4G


instead of=20

012228     1430          0D
012228     1430            0D
012229      600          4G
012229          600              4G

Is this more explanatory??  Let me know is more info is needed.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lex de Haan
Sent: Monday, May 23, 2005 10:49 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: A How-To

From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx]=20
Sent: Monday, May 23, 2005 17:46
To: 'BurtonL@xxxxxxxxxxx'; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: A How-To
Laura,

please provide some more info -- like a describe of the two tables
involved?
also, showing headings above your query results below, and the queries
themselves, would help enormously :-)

kind regards,

Lex.
=20
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Burton, Laura
Sent: Monday, May 23, 2005 17:25
To: oracle-l@xxxxxxxxxxxxx
Subject: A How-To

I have a table which has multiple records for one individual.  Each
record
represents a different field, i.e. id 31 represents start time, id 19
represents
shift, id 10 represents rate, etc.
=20

What I want is to have each record to be listed as a column in a select
statement so that I have a line that shows the following:



--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: