Oracle database prior to 8.1.6 only had DECODE function. CASE was introduced in Oracle 8.1.6 as a standard, more meaningful and more powerful function. Everything DECODE can do, CASE can. There is a ...

Friends,I'm trying to write a select statement that ends like this:and sc.customer_name in (DECODE(shipto,'0',sc.customer_name,shipto));The trouble is that shipto contains a comma delimted list. I ...

On the latest episode of Recode Decode, hosted by Kara Swisher, Hurd talked about his efforts to push big changes through at Oracle even though the 40-year-old enterprise company didn’t fit into ...