The PL/SQL trim function removes all specified characters from the left-hand and right-hand side of a string. If you wish to see the syntax and some examples read this article.
The PL/SQL rtrim function removes all specified characters from the right-hand side of a string. If you wish to see the syntax and some examples read this article.
The PL/SQL ltrim function removes all specified characters from the left-hand side of a string. If you wish to see the syntax and some examples read this article.
The PL/SQL the rpad function pads the right-side of a string with a specific set of characters. If you wish to see the syntax and some examples read this article.
The PL/SQL the lpad function pads the left-side of a string with a specific set of characters. If you wish to see the syntax and some examples read this article.
The PL/SQL the lower function converts all letters in the input string to lowercase. If you wish to see the syntax and some examples read this article.
The PLS/QL length function returns the length of the specified input string. If you wish to see the syntax and some examples read this article.
The PLS/QL instr function returns the location of a substring in a string. If you wish to see the syntax and some examples read this article.
In PL/SQLthe initcap function sets the first character in each word to uppercase and the rest to lowercase. The function name comse from words Initial Capitalics. If you wish to see the syntax and some examples read this article.
In PL/SQL the decompose function accepts a string and returns a a new Unicode converted string. If you wish to see the syntax and some examples read this article.
In PL/SQL the concat function allows you to concatenate two strings together. If you wish to see the syntax and some examples read this article.
In PL/SQL, the CHR function is the opposite of the built in ACSII function. It returns the character based on the ascii NUMBER code. If you wish to see the syntax and some examples read this article.
In PL/SQL, the the asciistr function converts a string in any character set to an ASCII string using the default database character set. If you wish to see the syntax and some examples read this article.
In PL/SQL an ASCII function returns the code (NUMBER) that represents the specified ascii character. If you wish to see the syntax and some examples read this article.