-- numbers_nobit表中包含如下字段和数据
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 SQRT(numberb) sqrt1,
SQRT(numberc) sqrt2,
SQRT(numberd) sqrt3,
SQRT(numbere) sqrt4,
SQRT(numberg) sqrt5
FROM numbers_nobit;
SQRT1 SQRT2 SQRT3 SQRT4 SQRT5
----------- ----------- ----------- ----------- -----------
7.41619849 74.5318724 2357022604 2.357E+000 23.558438
SELECT TYPEOF(SQRT(numberb)) type1,
TYPEOF(SQRT(numberc)) type2,
TYPEOF(SQRT(numberd)) type3,
TYPEOF(SQRT(numbere)) type4,
TYPEOF(SQRT(numberg)) type5
FROM numbers_nobit;
TYPE1 TYPE2 TYPE3 TYPE4 TYPE5
----------- ----------- ---------- --------- ---------
number number number float number
评论