Functions


Scalar Functions



Aggregate Functions


AVG ([Distinct | All | n]) - Average of values
COUNT - Total number of rows
MIN (column_name) - Minimum Value in a column ( or expression )
MAX (column_name) - Maximum Value


STDEV - Standard Deviation
STDEVP - Population estimate
SUM ([Distinct | All | n]) - Creates a column value that is the numeric sum of the values in the expression or column name specified
VAR - Average of the square of the difference from the mean
VARP - An estimate of the variance for the entire population


Useful Functions

Type Comment
Type ConversionTo_Number()Converts the input to a number
Type ConversionTo_Char()Converts the input to a character string
Type ConversionTo_Date(input, date format the input is in)Converts the input to the default date format
 Round( ) 
 Mod( , ) 
 NVL(column_value,value returned if Null) 
 DECODE(Used like an If statement or case statement
 COUNT 
StringSUBSTR(original text, length you want, start position) 
StringTRUNC( 
 IN (list or array of values) 
 DUALRefers to a table with just one row - used to return a single value
StringUPPER()Converts the text string to uppercase
 LOWER() 
 INITCAP() 
 MONTHS_BETWEEN 
 ADD_MONTHS 
 NEXT_DAY 
 LAST_DAY 
Single RowAVG 
 MAX 
 MIN 
 SUM 
 STDDEV 
 VARIANCE 


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext