ORACLE 常用字符函数

ORACLE 常用字符函数

页内导航

• 1 ASCII(arg1)
• 2 CHR(arg1,[using nchar_cs])
• 3 CONCAT(arg1,arg2)
• 4 INITCAP(arg1)
• 5 INSTR(arg1,to_find,pos,occurrence)
• 6 LENGTH(arg1)
• 7 lower(arg1)
• 8 LPAD(arg1,n,arg3)
• 9 LTRIM(arg1,arg2)
• 10 NLS_INITCAP(arg1,[‘NLS_SORT=x’])
• 11 NLS_LOWER(arg1,[‘NLS_SORT=x’])
• 12 NLSSORT(arg1,[‘NLS_SORT=x’])
• 13 NSL_UPPER(arg1,[‘NLS_SORT=x’])
• 14 REGEXP_INSTR(source,regex,[pos],[occurrence],[return_option],[match])
• 15 REGEXP_REPLACE(source,regex,replace,[pos],[occurrence],[match])
• 16 EGEXP_SUBSTR(source,regex,[pos],[occurrence],[match])
• 17 REPLACE(arg1,search,replace)
• 18 RPAD(arg1,n,arg3)
• 19 RTRIM(arg1,arg2)
• 20 SOUNDEX(arg1)
• 21.SUBSTR(arg1,pos.len)
• 22 TRANSLATE(arg1,match,replace)
• 23 TREAT(expr as [REF] schema.type)
• 24 TRIM([LEADING][TRAILING][BOTH] char FROM source)