sql - Decode function in oracle database - Stack Overflow
Feb 20, 2012 · Decode function in oracle database Asked 13 years, 10 months ago Modified 6 years, 8 months ago Viewed 82k times
DECODE Oracle SQL - Stack Overflow
Oct 25, 2014 · SELECT promo_id, DECODE(NVL(promo_cost,0),promo_cost, promo_cost * 0.25, 100) "Discount" FROM promotions; SELECT promo_id, DECODE(promo_cost,10000, …
oracle: decode and subquery select result - Stack Overflow
Jul 27, 2012 · I have a oracle query and part of it is calculating some value using DECODE. For example: SELECT ..., (SELECT DECODE((SELECT 23 FROM DUAL), 0, null, ...
Comparing dates in Oracle using the decode function
Sep 1, 2010 · That function will return date2 if date2 <= date1. Plugging in the values and translating to pseudo-code, you get if 0 - 0 = 0 then date2 else date1 where both dates are the …
oracle database - SQL Decode Null Values - Stack Overflow
Mar 15, 2012 · DECODE has some strange behavior: "In a DECODE function, Oracle considers two nulls to be equivalent." That behavior is not mentioned in the TechOnTheNet article.
How to use Oracle's decode function in where clause
Jun 8, 2015 · How to use Oracle's decode function in where clause Asked 10 years, 6 months ago Modified 10 years, 6 months ago Viewed 41k times
sql - CASE vs. DECODE - Stack Overflow
Jul 7, 2010 · Another point from the same article: "decode is the function Oracle originally provided with releases of the database prior to 8.1.6. Starting with 816, CASE is the standard …
decode two values using oracle decode - Stack Overflow
Sep 5, 2013 · select status_a,status_b from test how to decode status_a,status_b below values using oracle decode function aand if one of the values of status_a or status_b is null. if …
Decode function inside a decode function in SQL
Sep 11, 2019 · What does the sql statement below print with explanation please: SELECT DECODE (2, 2, DECODE(3, 7, 2, 4, 5, 6)) FROM DUAL I understand the decode function …
MySQL equivalent of DECODE function in Oracle - Stack Overflow
Jan 16, 2011 · The DECODE function will compare value of column 'Age' with 13, 14, 15.. and return appropriate string value 'Thirteen', 'Fourteen'.. and if it matches with nothing, then …