sql-server和oracle常用函數(shù)對比-文庫吧在線文庫
【正文】 lect log() value 1O:select ln() value from dual。) value from dualS:select char(97) valueO:select chr(97) value from dualS:select 39。,39。,39。,39。, 2, 3, 39。) value from dualS:沒發(fā)現(xiàn)O:select Translate(39。) value from dual（LPAD的第一個參數(shù)為空格則同space函數(shù)）S:select space(10)+39。,14) value from dualS:ltrim,rtrimO:ltrim,rtrim,trim33. 重復(fù)字符串S:select REPLICATE(39。), SOUNDEX (39。) value from dualS:select convert(char(8),getdate(),108) valueO:select to_char(sysdate,39。yyyymmdd hh24miss39。 ) vaule FROM DUAL。S:不知道O:SELECT New_time(sysdate,39。2004090839。, 39。), SOUNDEX (39。,14) value from dual（RPAD的第一個參數(shù)為空格則同space函數(shù)）S:select 39。,39。, 39。,2,2) valueO:select substr(39。,39。,39。+39。S:select sign(8) value 1O:select sign(8) value from dual 1S:SELECT PI() value O:不知道,cos,tan 參數(shù)都以弧度為單位例如：select sin(PI()/2) value 得到1（SQLServer）,Acos
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1