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)