The Oracle String functions manipulate the character strings more effectively.
| Functions |
Description |
| ASCII() |
The ASCII() function returns the numeric value of given character. |
| ASCIISTR() |
The ASCIISTR() function returns the numeric value of given character. |
| CHR() |
The Oracle CHR() function returns all the characters of the given ASCII code. |
| COMPOSE() |
The Oracle COMPOSE() function returns the Unicode string. |
| CONCAT() |
The Oracle CONCAT() function returns a string by concatenating all the arguments. |
| CONCAT WITH || |
The Oracle CONCAT WITH || function returns a string by concatenating all the arguments. |
| CONVERT() |
The Oracle CONVERT() function is used to convert one string set to another. |
| DECOMPOSE() |
The DECOMPOSE() function returns a Unicode string from the given string. |
| DUMP() |
The DUMP() function returns the string datatype code, length in bytes and some internal representation of the given string. |
| INSTR4() |
The Oracle INSTR4() function returns the location of the substring using UCS4 code points from the given string. |
| INSTRB() |
The Oracle INSTRB() function returns the location of substring using bytes instead of characters from the given string. |
| INSTRC() |
The INSTRC() function returns the location of the substring using Unicode complete characters from the given string. |
| LENGTH2() |
The LENGTH2() function returns the size using UCS2 code points of the given string. |
| LENGTH4() |
The Oracle LENGTH4() function returns the size using UCS4 code points of the given string. |
| LENGTHB() |
The LENGTHB() function returns the size using bytes instead of characters from the given string. |
| LENGTHC() |
The LENGTHC() function returns the size using Unicode complete characters from the given string. |
| LENGTH() |
The Oracle LENGTH() function returns the size of the given string. |
| LOWER() |
The Oracle LOWER() function returns the given string into the lower case. |
| LPAD() |
The LPAD() returns the left padded to the given length. |
| LTRIM() |
The LTRIM() function returns the string by removing given characters from the left side. |
| NCHR() |
The NCHR() function returns the character which is based on the number_code in the national character set. |
| REGEXP_INSTR() |
The Oracle REGEXP_INSTR() function is used for pattern matching in a string. |
| REGEXP_REPLACE() |
The REGEXP_REPLACE() function is used for pattern matching and replacing the sequence of characters. |
| REGEXP_SUBSTR() |
The REGEXP_SUBSTR()function is used for pattern matching in substring from a string. |
| REPLACE() |
The Oracle REPLACE() function is used to replace the sequence of character with another character in the given string. |
| RPAD() |
The RPAD() function returns the right-padded to the given length. |
| RTRIM() |
The Oracle RTRIM() function returns the string by removing given characters from the right side. |
| SOUNDEX() |
The SOUNDEX() function returns a Soundex string which sounds almost same and have identical soundex strings. |
| SUBSTR() |
The Oracle SUBSTR() function is used to extract the substring from the given string. |
| TRANSLATE() |
The TRANSLATE() function is used to replace the character from the given character. This function replaces one character only. |
| TRIM() |
The Oracle TRIM() function is used to remove the specified character from the head of the string or tail of the string. |
| UPPER() |
The Upper() function is used to convert the given string into uppercase. |
| VSIZE() |
The Oracle VSIZE() function returns the number of bytes of the given expression. |
Home
Oracle
SQL
PL/SQL
MySQL
MongoDB
PostgreSQL
SQL Server
SQLite
Cassandra
DBMS
Python
Java
Aptitude
Interview Q
For Videos Join Our Youtube Channel: Join Now
