TRIM

RTRIM()

RTRIM removes from the right end of char all of the characters that appear in set This function is useful for formatting the output of a query If you do not specify set, then it defaults to a single blank SIMILAR TO LTRIM Example SELECT RTRIM(‘<=====>BROWNING<=====>’, ‘<>=’) “RTRIM Example” FROM DUAL; RTRIM Example ————— <=====>BROWNING

RTRIM() Read More »

LTRIM()

  LTRIM(char [, set ]) LTRIM removes from the left end of char all of the characters contained in If no set is specified, it removes a single blank space. Both char and set can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 data type if char is a character data type, NVARCHAR2 if char is a national character data type, and a LOB

LTRIM() Read More »

Scroll to Top