trunc and trim function
what is the difference between trunc and trim function
Trim- enables to trim the
Trim- enables to trim the characters from the string i.e from either sides
Eg: trim ('0' from '001')
Trunc- truncates the value to specified decimal
Eg:trunc(198.06 2)
or truncates the date to nearest date
Eg:trunc(sysdate 'year')