select id,decode(sign(date1-sysdate-7),1,'Date1成立',0,'Date1成立') || decode(sign(date2-sysdate-7),1,'Date2成立',0,'Date2成立') from table1 where date1>sysdate-7 or date2>sysdate-7
select id,decode(sign(date1-sysdate-7),1,'Date1成立',-1,'Date1不成立') ,decode(sign(date2-sysdate-7),1,'Date2成立',-1,'Date2不成立') decode(sign(date2-sysdate-7)+sign(date2-sysdate-7),2,'Date1,Date2成立') from table1 where date1>sysdate-7 or date2>sysdate-7
SELECT id, decode(SIGN(datea - SYSDATE + 7), 1, 'Date1成立') || decode(SIGN(dateb - SYSDATE + 7), 1, 'Date2成立') FROM a WHERE datea > SYSDATE - 7 OR dateb > SYSDATE - 7
SELECT product_id,
DECODE (warehouse_id, 1, 'Southlake',
2, 'San Francisco',
3, 'New Jersey',
4, 'Seattle',
'Non-domestic')
quantity_on_hand FROM inventories;
SELECT product_id,
DECODE (warehouse_id, 1, 'Southlake',
2, 'San Francisco',
3, 'New Jersey',
4, 'Seattle',
'Non-domestic')
quantity_on_hand FROM inventories;
quantity_on_hand 是什么意思?
DECODE (warehouse_id, warehouse_id>1, 'Southlake',
warehouse_id<1, 'San Francisco')
quantity_on_hand FROM inventories;
|| decode(sign(date2-sysdate-7),1,'Date2成立',0,'Date2成立')
from table1
where date1>sysdate-7 or date2>sysdate-7
,decode(sign(date2-sysdate-7),1,'Date2成立',-1,'Date2不成立')
decode(sign(date2-sysdate-7)+sign(date2-sysdate-7),2,'Date1,Date2成立')
from table1
where date1>sysdate-7 or date2>sysdate-7
|| decode(SIGN(dateb - SYSDATE + 7), 1, 'Date2成立')
FROM a
WHERE datea > SYSDATE - 7 OR
dateb > SYSDATE - 7