Hey folks,
Now I've seen some odd results form queries in the past, but I'll be d*mned
is I can figure this one out. It defies logic.
I've two queries that each return 50 rows from the database & the rows are
the same is each case (stubby pencil check), but of the three columns returned
the last two reverse. I'm including the SQL, a sample result set, and the view
definitions that are being used. If you can figure it out, please let me know.
I'm asking OTS as well.
Dick Goulet
Here is the data:
select pd.product_id, pts.PART_TYPE, pts.PART_NUM
2 from specsrv.mfg_products pd, vmecs.parts pts
3 where pts.part_type = pd.PART_TYPe
4 and pd.product_id in (6650,6550,6750,35,9920);
PRODUCT_ID PART_TYPE PART_NUM
---------- -------------------- --------------------
9920 BR-FT48C12C150A BRAIN_ASSY_FT
9920 4-FT48C5C100A BRAIN_ASSY_FT
9920 4-FT48C2C50A BRAIN_ASSY_FT
9920 4-FT48C12C150A BRAIN_ASSY_FT
9920 4-FT48C28C150A BRAIN_ASSY_FT
9920 4-SS48B15C250A BRAIN_ASSY_FT
9920 BR-FT48B2C100A BRAIN_ASSY_FT
9920 4-VI-810718 BRAIN_ASSY_FT
9920 4-FT300B15C250A BRAIN_ASSY_FT
9920 BR-FT48B15C250A BRAIN_ASSY_FT
9920 4-FT48B15C250A BRAIN_ASSY_FT
9920 BR-FT48B5C200A BRAIN_ASSY_FT
9920 BR-FT48B28C250A BRAIN_ASSY_FT
9920 4-FT48C3V3C75A BRAIN_ASSY_FT
9920 4-FT48C24C150A BRAIN_ASSY_FT
9920 4-HT-810354 BRAIN_ASSY_FT
9920 4-FT48B2C100A BRAIN_ASSY_FT
9920 4-FT48B5C200A BRAIN_ASSY_FT
9920 4-GW-810354 BRAIN_ASSY_FT
9920 4-VI-810354 BRAIN_ASSY_FT
9920 BR-FT300B15C250A BRAIN_ASSY_FT
select pd.product_id, pts.PART_TYPE, pts.PART_NUM
2 from specsrv.mfg_products pd, vmecs.parts pts
3 where RTRIM(pts.part_type) = pd.PART_TYPE
4 and pd.product_id in (6650,6550,6750,35,9920);
PRODUCT_ID PART_TYPE PART_NUM
---------- -------------------- --------------------
9920 BRAIN_ASSY_FT BR-FT48C12C150A
9920 BRAIN_ASSY_FT 4-FT48C5C100A
9920 BRAIN_ASSY_FT 4-FT48C2C50A
9920 BRAIN_ASSY_FT 4-FT48C12C150A
9920 BRAIN_ASSY_FT 4-FT48C28C150A
9920 BRAIN_ASSY_FT 4-SS48B15C250A
9920 BRAIN_ASSY_FT BR-FT48B2C100A
9920 BRAIN_ASSY_FT 4-VI-810718
9920 BRAIN_ASSY_FT 4-FT300B15C250A
9920 BRAIN_ASSY_FT BR-FT48B15C250A
9920 BRAIN_ASSY_FT 4-FT48B15C250A
9920 BRAIN_ASSY_FT BR-FT48B5C200A
9920 BRAIN_ASSY_FT BR-FT48B28C250A
9920 BRAIN_ASSY_FT 4-FT48C3V3C75A
9920 BRAIN_ASSY_FT 4-FT48C24C150A
9920 BRAIN_ASSY_FT 4-HT-810354
9920 BRAIN_ASSY_FT 4-FT48B2C100A
9920 BRAIN_ASSY_FT 4-FT48B5C200A
9920 BRAIN_ASSY_FT 4-GW-810354
9920 BRAIN_ASSY_FT 4-VI-810354
9920 BRAIN_ASSY_FT BR-FT300B15C250A
desc vmecs.parts
Name Null? Type
---------------------------------------- -------- ---------------
PART_NUM NOT NULL VARCHAR2(20)
PART_REV VARCHAR2(2)
DESCRIPTION VARCHAR2(30)
PART_TYPE VARCHAR2(20)
PAN_TYPE VARCHAR2(20)
PAN_SIZE NUMBER(22)
STOCKING_UOM VARCHAR2(2)
BUYER VARCHAR2(2)
SOURCE_CODE VARCHAR2(2)
CLASS_CODE NUMBER(22)
NUM_ERRORS NUMBER(22)
DATE_CHANGED DATE
desc specsrv.mfg_products
Name Null? Type
---------------------------------------- -------- -------------
PRODUCT_ID NOT NULL NUMBER
PRODUCT_NAME VARCHAR2(60)
PART_TYPE VARCHAR2(61)
PROD_DESC NOT NULL VARCHAR2(60)
CONFIGURABLE NOT NULL VARCHAR2(1)
SPEC_TABLE_NAME VARCHAR2(40)
NUM_SMD_BRDS NUMBER
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
