Oracleϵͳº¯ÊýÖ®ÀàµÄ

×Ö·ûº¯Êý
ÏÂÃæÊÇOracleÖ§³ÖµÄ×Ö·ûº¯ÊýºÍËüÃǵÄMicrosoft SQL ServerµÈ¼Ûº¯Êý¡£
º¯Êý Oracle Microsoft SQL¡¡Server
°Ñ×Ö·ûת»»ÎªASCII :ASCII ASCII
×Ö´®Á¬½Ó: CONCAT --------------(expression + expression)
°ÑASCIIת»»Îª×Ö·û CHR, CHAR
·µ»Ø×Ö·û´®ÖеĿªÊ¼×Ö·û£¨×óÆ𣩠INSTR ,---------------CHARINDEX
°Ñ×Ö·ûת»»ÎªÐ¡Ð´ LOWER ---------------------LOWER
°Ñ×Ö·ûת»»Îª´óд UPPER-------------------- UPPER
Ìî³ä×Ö·û´®µÄ×ó±ß LPAD --------------------N/A
Çå³ý¿ªÊ¼µÄ¿Õ°× LTRIM--------------------LTRIM
Çå³ýβ²¿µÄ¿Õ°× RTRIM --------------------RTRIM
×Ö·û´®ÖеÄÆðʼģʽ£¨pattern£© INSTR --------------------PATINDEX
¶à´ÎÖظ´×Ö·û´® RPAD --------------------REPLICATE
×Ö·û´®µÄÓïÒô±íʾ SOUNDEX --------------------SOUNDEX
Öظ´¿Õ¸ñµÄ×Ö´® RPAD --------------------SPACE
´ÓÊý×ÖÊý¾Ýת»»Îª×Ö·ûÊý¾Ý TO_CHAR --------------------STR
×Ó´® SUBSTR --------------------SUBSTRING
Ìæ»»×Ö·û REPLACE --------------------STUFF
½«×Ö´®ÖеÄÿ¸ö´ÊÊ××Öĸ´óд INITCAP --------------------N/A
·­Òë×Ö·û´® TRANSLATE --------------------N/A
×Ö·û´®³¤¶È LENGTH-------------------- DATELENGTH or LEN
ÁбíÖÐ×î´óµÄ×Ö·û´® GREATEST-------------------- N/A
ÁбíÖÐ×îСµÄ×Ö·û´® LEAST --------------------N/A
Èç¹ûΪNULLÔòת»»×Ö´® NVL-------------------- ISNULL
ÈÕÆÚº¯Êý
ÏÂÃæÊÇOracleÖ§³ÖµÄÈÕÆÚº¯ÊýºÍËüÃǵÄMicrosoft SQL ServerµÈ¼Ûº¯Êý¡£
º¯Êý Oracle --------------------Microsoft SQL¡¡Server
ÈÕÆÚÏà¼Ó (date column +/- value) or ADD_MONTHS --------------------DATEADD
Á½¸öÈÕÆڵIJî (date column +/- value) or MONTHS_BETWEEN --------------------DATEDIFF
µ±Ç°ÈÕÆÚºÍʱ¼ä SYSDATE --------------------GETDATE()
Ò»¸öÔµÄ×îºóÒ»Ìì LAST_DAY --------------------N/A
ʱÇøת»» NEW_TIME --------------------N/A
ÈÕÆÚºóµÄµÚÒ»¸öÖÜÈÕ NEXT_DAY --------------------N/A
´ú±íÈÕÆÚµÄ×Ö·û´® TO_CHAR --------------------DATENAME
´ú±íÈÕÆÚµÄÕûÊý TO_NUMBER (TO_CHAR)) --------------------DATEPART
ÈÕÆÚÉáÈë ROUND --------------------CONVERT
ÈÕÆÚ½Ø¶Ï TRUNC --------------------CONVERT
×Ö·û´®×ª»»ÎªÈÕÆÚ TO_DATE ------------------