SELECT numbera,numberb,numberc,numberd,numbere,numberf,numberg FROM numbers_nobit; NUMBERA NUMBERB NUMBERC NUMBERD NUMBERE NUMBERF NUMBERG------------ ------- -------- --------------------- ----------- ----------- ----------- -5 55 5555 5555555555555555555 5.555E+000 5.556E+000 555 SELECT DIV(numberb,numbera) div1,DIV(numberd,numbere) div2,DIV(numberf,numberc) div3,DIV(numbera,'17') div4,DIV(numberf,0) div5FROM numbers_nobit; DIV1 DIV2 DIV3 DIV4 DIV5--------------------- ----------- ----------- ----------- ----------- -11 1.0E+018 1.0E-003 -.29411765 Inf SELECT TYPEOF(DIV(numberb,numbera)) type1,TYPEOF(DIV(numberd,numbere)) type2,TYPEOF(DIV(numberf,numberc)) type3,TYPEOF(DIV(numbera,'17')) type4,TYPEOF(DIV(numberf,0)) type5FROM numbers_nobit;TYPE1 TYPE2 TYPE3 TYPE4 TYPE5 ---------- -------- --------- -------- ---------bigint float double number double SELECT DIV(CAST('Nan' AS FLOAT), CAST('Inf' AS DOUBLE)) ndi,DIV(CAST('-Inf' AS FLOAT), 0) id0,DIV(12, CAST('-Inf' AS DOUBLE)) ndi,DIV(12, CAST('Nan' AS FLOAT)) mdn,DIV(CAST('-Inf' AS FLOAT), CAST('Inf' AS DOUBLE)) idiFROM DUAL; NDI ID0 NDI MDN IDI----------- ----------- ----------- ----------- ----------- Nan -Inf 0 Nan Nan
评论