CHR17 Mar 2025 | 1 min read CHR is a String function of Oracle. This function returns all the characters of the given ASCII code. SyntaxParametersnumber: It is the NUMBER code which is used to retrieve the character ReturnsThis function returns a string value. Example 1![]() Example 2![]() Next TopicOracle String |
is a String function of Oracle. This function returns the numeric value of given character. Syntax (character) Parameters character: It is the specified character to retrieve the NUMBER code for Returns This function returns the numeric value of given character. Example 1 SELECT ('J') FROM DUAL Example 2 SELECT ('o') FROM DUAL TopicOracle String ...
1 min read
Oracle Function RPAD is a String function of Oracle. This function returns the right-padded to the given length. Syntax RPAD( string1, padded_length [, pad_string] ) Parameters string1: string to be padded from the right. padded_length : length to be padded from the right. pad_string: it is optional. It is the string that...
1 min read
Oracle Function REPLACE is a String function of Oracle. This function is used to replace the sequence of character with another character in the given string. Syntax REPLACE( string1, string_to_replace [, replacement_string] ) Parameters string1 : string to be replaced from the sequence of characters. string_to_replace : string to be...
1 min read
Oracle Function LTRIM(str) is a String function of Oracle. This function returns the string by removing given characters from left side. Syntax LTRIM( string1 [, trim_string] ) Parameters string1 : string to be trimmed from left-hand side. trim_string : it is optional. It is the string to be removed from the...
1 min read
Oracle Function RTRIM(str) is a String function of Oracle. This function returns the string by removing given characters from the right side. Syntax RTRIM( string1 [, trim_string] ) Parameters string1 : string to be trimmed from right-hand side. trim_string : it is optional. It is the string to be removed from...
1 min read
Oracle Function TRANSLATE is a String function of Oracle. This function is used to replace the character from the given character. This function replaces one character only. Syntax TRANSLATE(string1, string_to_replace, replacement_string) Parameters string1 : string to be replace from sequence of characters. string_to_replace : string to be search in string for...
1 min read
Oracle Function LENGTH is a String function of Oracle. This function returns the size of the given string. Syntax LENGTH( string1 ) Parameters string1: string for getting the length. Return This function returns a numeric value. Example 1 Select length('oracle') from dual; Example 2 Select length('javatpoint') from dual; TopicOracle String ...
1 min read
Oracle Function LENGTHC is a String function of Oracle. This function returns the size using Unicode complete characters from the given string. Syntax LENGTHC( string1 ) Parameters string1: string for getting length. Return This function returns a numeric value. Example 1 Select lengthc('oracle') from dual; Example 2 Select lengthc('javatpoint') from dual; TopicOracle String ...
1 min read
Oracle Function LPAD is a String function of Oracle. This function returns the left padded to the given length. Syntax LPAD( string1, padded_length [, pad_string] ) Parameters string1: string to be padded from left. padded_length : length to be padded from left. pad_string: it is optional. It is the string that will...
1 min read
is a String function of Oracle. This function returns a Unicode string from the given string. Syntax (string) Parameters string: string to be decompose. Return This function returns a Unicode string. Example 1 Select decompose('jâvâ') from dual; Example 2 Select decompose('öracle') from dual; TopicOracle String ...
1 min read
We request you to subscribe our newsletter for upcoming updates.
We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks
G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India