RE: A How-To

From: Burton, Laura <BurtonL_at_frmaint.com>
Date: Mon, 23 May 2005 11:16:18 -0500
Message-ID: <B5E0B4818A669C49A9C22199D9C389F80391865C@MAIL.frmaint.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lex de Haan
Sent: Monday, May 23, 2005 10:49 AM
To: oracle-l_at_freelists.org
Subject: RE: A How-To

From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]=20 Sent: Monday, May 23, 2005 17:46
To: 'BurtonL_at_frmaint.com'; 'oracle-l_at_freelists.org' 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Burton, Laura
Sent: Monday, May 23, 2005 17:25
To: oracle-l_at_freelists.org
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

Received on Mon May 23 2005 - 12:23:24 CDT