1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

Mathematical Functions in Oracle:

Mathematical Functions:
ABS(X) Absolute value-converts negative numbers to positive, or leaves positive numbers alone
CEIL(X) X is a decimal value that will be rounded up.
FLOOR(X) X is a decimal value that will be rounded down.
SQL Tutorial
http://w3.one.net/~jhoffman/sqltut.htm Page 27
04/07/2001
GREATEST(X,Y) Returns the largest of the two values.
LEAST(X,Y) Returns the smallest of the two values.
MOD(X,Y) Returns the remainder of X / Y.
POWER(X,Y) Returns X to the power of Y.
ROUND(X,Y) Rounds X to Y decimal places. If Y is omitted, X is rounded to the nearest integer.
SIGN(X) Returns a minus if X < 0, else a plus.
SQRT(X) Returns the square root of X.
Character Functions
LEFT(<string>,X) Returns the leftmost X characters of the string.
RIGHT(<string>,X) Returns the rightmost X characters of the string.
UPPER(<string>) Converts the string to all uppercase letters.
LOWER(<string>) Converts the string to all lowercase letters.
INITCAP(<string>) Converts the string to initial caps.
LENGTH(<string>) Returns the number of characters in the string.
<string>||<string> Combines the two strings of text into one, concatenated string, where the first
string is immediately followed by the second.
LPAD(<string>,X,'*') Pads the string on the left with the * (or whatever character is inside the quotes),
to make the string X characters long.
RPAD(<string>,X,'*') Pads the string on the right with the * (or whatever character is inside the quotes),
to make the string X characters long.
SUBSTR(<string>,X,Y) Extracts Y letters from the string beginning at position X.
NVL(<column>,<value>) The Null value function will substitute <value> for any NULLs for in the
<column>. If the current value of <column> is not NULL, NVL has no effect