data 102
we have separate functions for dates numbers and strings.
pg 338
the INSTR (instring) function searches a specified set of characters or a substring and then returns a numeric value representing the first character position in which the substring is found.
LPAD & RPAD
can be used to fill in the area next to a character string with a specific character or even a blank space.
the syntax of the function is LPAD(c,l,s) and RPAD(c,l,s) where c represents the character string to pad, l represents the length of the character string after padding, and s represents the symbol or character to use as padding.
ROUND and TRUNC funtions can be used on numbers and dates.
pg 338
the INSTR (instring) function searches a specified set of characters or a substring and then returns a numeric value representing the first character position in which the substring is found.
LPAD & RPAD
can be used to fill in the area next to a character string with a specific character or even a blank space.
the syntax of the function is LPAD(c,l,s) and RPAD(c,l,s) where c represents the character string to pad, l represents the length of the character string after padding, and s represents the symbol or character to use as padding.
ROUND and TRUNC funtions can be used on numbers and dates.