troubleshooting Question

oracle decode statement

Avatar of anumoses
anumosesFlag for United States of America asked on
Oracle Database
6 Comments1 Solution576 ViewsLast Modified:
SELECT BATCH_ID,
             PRODUCT_CODE,
             UNIT_ID,
             TIME_FROM_COLLECTION,
             to_char(FILTRATION_START,' MM/DD/RRRR HH24:MI')    
             filtration_start,FILTRATION_START_USER,
             to_char(FILTRATION_END,'MM/DD/RRRR HH24:MI') filtration_end,                
             FILTRATION_END_USER,
             TOTAL_ELAPSED_TIME,
             decode(COLOR_RESULT,'RED','Y','N') color_result, TOTAL_ELAPSED_COLOR,
             BAG_CODE, FILTRATION_COMMENTS||chr(10)||SUPERVISOR_COMMENTS  
             comments,
             FAILED_FLAG, RECORD_MODIFIED,
             decode(WAREHOUSE_ID ,'A','Aurora','Tinley Park') warehouse_id
             from  AU_LEUKOREDUCTION_TRACKING_VW1
             where warehouse_id = 'A'
            and bag_code = '54'
           and filtration_start = '08-feb-2012' ;
My question is decode(COLOR_RESULT,'RED','Y','N') color_result, TOTAL_ELAPSED_COLOR,
I want to color_result or total_elapsed_color if 'RED' the 'Y' else 'N' . How can I do that in decode ?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros