{"id":19287,"date":"2021-08-17T08:35:54","date_gmt":"2021-08-16T22:35:54","guid":{"rendered":"https:\/\/database.guide\/?p=19287"},"modified":"2021-08-17T08:35:54","modified_gmt":"2021-08-16T22:35:54","slug":"oracle-string-functions-full-list","status":"publish","type":"post","link":"https:\/\/database.guide\/oracle-string-functions-full-list\/","title":{"rendered":"Oracle String Functions (Full List)"},"content":{"rendered":"\n

Below is a list of built-in string\/character functions that are available in Oracle Database.<\/p>\n\n\n\n\n\n\n\n

Function<\/th>Description<\/th><\/tr><\/thead>
ASCII()<\/a><\/code><\/td>Returns the decimal representation in the database character set of the first character of its argument.<\/td><\/tr>
CHR()<\/a><\/code><\/td>Returns a character based on the code values provided as an argument.<\/td><\/tr>
CONCAT()<\/a><\/code><\/td>Performs a string concatenation on its arguments.<\/td><\/tr>
INITCAP()<\/a><\/code><\/td>Returns its argument with the first letter of each word in uppercase, and all other letters in lowercase.<\/td><\/tr>
INSTR()<\/a><\/code><\/td>Searches for a substring in a given string, and returns an integer indicating the position of the first character of this substring.<\/td><\/tr>
LENGTH()<\/a><\/code><\/td>Returns the length of its argument. There are five separate functions; LENGTH()<\/code>, LENGTHB()<\/code>, LENGTHC()<\/code>, LENGTH2()<\/code>, and LENGTH4()<\/code>. Each function calculates the length in a different way.<\/td><\/tr>
LOWER()<\/a><\/code><\/td>Returns its argument with all letters in lowercase.<\/td><\/tr>
LPAD()<\/a><\/code><\/td>Pads the left part of a string with a certain character, to a specified number of characters.<\/td><\/tr>
LTRIM()<\/a><\/code><\/td>Trims the left part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.<\/td><\/tr>
NCHR()<\/a><\/code><\/td>Returns the character having the binary equivalent to its argument in the national character set.<\/td><\/tr>
NLS_INITCAP()<\/a><\/code><\/td>Similar to the INITCAP()<\/a><\/code> function, except that it accepts a second argument that allows you to specify the collation.<\/td><\/tr>
NLS_LOWER()<\/a><\/code><\/td>Similar to the LOWER()<\/a><\/code> function, except that it accepts a second argument that allows you to specify the collation. <\/td><\/tr>
NLS_UPPER()<\/a><\/code><\/td>Similar to the UPPER()<\/a><\/code> function, except that it accepts a second argument that allows you to specify the collation.<\/td><\/tr>
NLSSORT()<\/a><\/code><\/td>Returns a collation key for a given character value and an explicitly or implicitly specified collation.<\/td><\/tr>
REGEXP_COUNT()<\/a><\/code><\/td>Returns the number of times a pattern occurs in a source string.<\/td><\/tr>
REGEXP_INSTR()<\/a><\/code><\/td>Extends the functionality of the INSTR()<\/a><\/code> function by allowing us to use regular expression patterns.<\/td><\/tr>
REGEXP_REPLACE()<\/a><\/code><\/td>Extends the functionality of the REPLACE()<\/a><\/code> function by allowing us to use regular expression patterns.<\/td><\/tr>
REGEXP_SUBSTR()<\/a><\/code><\/td>Extends the functionality of the SUBSTR()<\/a><\/code> function by allowing us to use regular expression patterns.<\/td><\/tr>
REPLACE()<\/a><\/code><\/td>Allows you to replace a part of a string with another string.<\/td><\/tr>
RPAD()<\/a><\/code><\/td>Pads the right part of a string with a certain character, to a specified number of characters.<\/td><\/tr>
RTRIM()<\/a><\/code><\/td>Trims the right part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.<\/td><\/tr>
SOUNDEX()<\/a><\/code><\/td>Returns a character string containing the phonetic representation of its argument.<\/td><\/tr>
SUBSTR()<\/a><\/code><\/td>Returns the specified substring from a given string.<\/td><\/tr>
TRANSLATE()<\/a><\/code><\/td>Allows you to make several single-character, one-to-one substitutions in one operation.<\/td><\/tr>
TRANSLATE(...USING)<\/a><\/code><\/td>Converts its argument into the character set specified for conversions between the database character set and the national character set. Not to be confused with the TRANSLATE()<\/code> function, which allows you to make several single-character, one-to-one substitutions in one operation. <\/td><\/tr>
TRIM()<\/a><\/code><\/td>Allows you to trim characters from the sides of a string. You can trim leading characters, trailing characters, or both.<\/td><\/tr>
UPPER()<\/a><\/code><\/td>Returns its argument with all letters in uppercase.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Below is a list of built-in string\/character functions that are available in Oracle Database.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[93,67],"class_list":["post-19287","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-functions","tag-string-functions"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/19287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=19287"}],"version-history":[{"count":5,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/19287\/revisions"}],"predecessor-version":[{"id":19629,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/19287\/revisions\/19629"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=19287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=19287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=19287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}