Arithmetic functionsround (n[,m]) | Round n on m decimal positions, default m=0 | trunc (n[,m]) | Truncate n on m decimal positions, default m=0 | ceil (n) | Round n upward to an integer | floor (n) | Round n downward to an integer | abs (n) | Absolute value of n | sign (n) | -1, 0, 1 if n is negative, zero, or positive | sqrt (n) | Square root of n | exp (n) | e raised to the nth power | ln(n), log(m, n) | Natural logarithm, and logarithm base m | power (n,m) | n raised to the mth power | mod (n,m) | Remainder of n divided by m (m can be 0) | sin(n), cos(n), tan(n) | Sine, cosine and tangent of n (radians) | asin(n), acos(n), atan(n) | Arcsine, arccosine, and arctangent of n | sinh(n), cosh(n), tanh(n) | Hyperbolic sine, hyperbolic cosine and hyperbolic tangent of n |
| | Text functions 1lenth (t) | Length (in characters) of t | ascii (t) | ASCII value of first character of t | chr (n) | Character with ASCII value of n | upper(t), lower(t) | t in uppercase/lowercase | initcap(t) | Each word in t with initial uppercase, remainder in lowercase | ltrim (t[,k]) | Remove characters from the left of t, until the first character not in k | rtrim (t[,k]) | Remove characters from the right of t, after the last character not in k | trim ([[option] [c from]]t) | Trim character c from t; option = leading, trailing, or both | lpad (t,n[,k]) | Left-pad t with sequence of characters in k to length n | rpad (t,n[,k]) | Right-pad t with k to length n; default k=space | concat (t1,t2) | Concatenate t1 and t2 (equivalent to ||) |
Regexp optionsi | Case-insensitive search | c | Case-sensitive search | n | Allow . to match the newline character | m | Treat text as multiple lines; ^ and $ refer to the beginning and the end of those lines |
If you specify conflicting combinations, such as ic, the Oracle DBMS uses the last value (c) and ignores the first one. | | Text functions 2substr (t,n[,m]) | Substring of t from position n, m character long; default m=end | instr (t,k) | Position of the first occurrence of k in t | instr (t,k,n) | n=starting position | instr (t,k,n,m) | m=mth occurrence of k | translate (t,v,w) | Replace characters from v (occurring in t) by corresponding character in w | replace (t,v) | Remove each occurrence of v from t | replace (t,v,w) | Replace each occurrence of v in t by w |
Regular expressionsregexp_like (text, pattern[, options]) | regexp_instr (text, pattern[, pos[,
occurrence[, return[, options]]]]) | regexp_substr (text, pattern[, pos[,
occurrence[, options]]]) | regexp_replace (text, pattern[, replace[, pos[, occurrence[, options]]]]) |
pos0 | Position of the first character of the pattern found (default) | 1 | Position of the first character after the pattern found |
|
Created By
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets
More Cheat Sheets by chunyan