Oracle TRIM() FunctionTRIM is a String function of Oracle. This function is used to remove the specified character from head of the string or tail of the string. SyntaxParametersLEADING : it will trim from head of the string. TRAILING: it will trim from tail of the string. BOTH : it will trim from head as well as from tail of the string. trim_character : character to be trimed from the string. string1 : string to be trimed. ReturnIt will return the string value. Example 1Example 2
Next TopicOracle String
|