Oracle 9i : Oracle Functions

DBAsupport.com : Oracle 9i Central : Listen Software Solutions’ “How To” Series : Oracle Functions: “Oracle String Functions

initcap(char) – Returns a char with the first letter of each word in uppercase
instr(char1, char2,n,m) – n=position m=occurance returns the numeric position of char2 in char1
length(char) – Length of char
lower(char) – Returns char with all lower case
lpad(char1,n,char2) – Return a char with char1 left pad with char2
ltrim(char) – Remove all leading spaces
rpad(char1,n,char2) – Returns char with char1 right pad with char2
rtrim(char) – Remove all trailing spaces
substr(char,m,n) – Returns substring start at m for n characters
upper(char) – Converts all characters to uppercase
chr(n) – Returns the ascii code equivalent
concat(char1, char2) – Return a char which is the result of char1 and char2
Oracle Time Functions

ADD_MONTHS(d,n) – Add n months to d date
LAST_DAY(d) – Returns last day of the month
MONTHS_BETWEEN(d1,d2) – Difference between d1 and d2
ROUND(d,fmt) – Round to format
TO_CHAR(string,format)
TO_DATE(string,format)
Oracle Number Functions

ABS(value) – Absolute value
CEIL(value) – Smallest integer larger than equal to value
COS(value) – Cosine value
EXP(value) – e raise to value
FLOOR(value) – Largest value smaller than equal to value
ROUND(value) – Rounding of value to precision
SIGN(value) – 1 if positive -1 if negative
SQRT(value) – Square root of value
TAN(value) – Tangent of value
TRUNC(value) – Value truncated to precision
Oracle Group Functions

Avg(value) – Average of value for a group of rows
Count(value) – Count rows of columns
Max(value) – Maximum of all value for groups of rows
Min(value) – Minimum of all values for groups of rows
Sum(value) – Sum of all values for groups of rows”

Advertisements
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: