sql-server和oracle常用函數(shù)對比-文庫吧
2025-07-08 01:58 本頁面
【正文】 s,tan 參數(shù)都以弧度為單位例如：select sin(PI()/2) value 得到1（SQLServer）,Acos,Atan,Atan2 返回弧度(SQLServer，Oracle不知道)DEGREES：弧度〉角度RADIANS：角度〉弧度數(shù)值間比較18. 求集合最大值S:select max(value) value from(select 1 valueunionselect 2 valueunionselect 4 valueunionselect 3 value)aO:select greatest(1,2,4,3) value from dual19. 求集合最小值S:select min(value) value from(select 1 valueunionselect 2 valueunionselect 4 valueunionselect 3 value)aO:select least(1,2,4,3) value from dual(F2中的null以10代替)S:select F1,IsNull(F2,10) value from TblO:select F1,nvl(F2,10) value from TblS:select ascii(39。a39。) valueO:select ascii(39。a39。) value from dualS:select char(97) valueO:select chr(97) value from dualS:select 39。1139。+39。2239。+39。3339。 valueO:select CONCAT(39。1139。,39。2239。)33 value from dual 返回3S:select CHARINDEX(39。s39。,39。sdsq39。,2) value
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1