In the above sample '09'xc denotes a tab. But what are the other options that can be in that place. What is that option.
Sorry, i didn't answer your previous post, i just forgot it.
XC indicates a hexadecimal string literal, i used it instead of a tab character enclosed in quotes because some editors replace a tab with something else, e.g. blanks.
Within TRIM this option indicates the character to be trimmed, the default is a blank.
You'll find more details in the manuals:
SQL Functions and Operators -> TRIM
SQL Datatypes and Literals -> ''XC