{"id":13626,"date":"2024-03-15T07:31:14","date_gmt":"2024-03-15T07:31:14","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/"},"modified":"2025-08-05T21:14:20","modified_gmt":"2025-08-05T21:14:20","slug":"how-is-the-regexp_replace-function-used-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/","title":{"rendered":"Oracle REGEXP_REPLACE Function Guide"},"content":{"rendered":"

The REGEXP_REPLACE function in Oracle is used to replace parts of a string that match a specified pattern. Its syntax is as follows:<\/p>\n

Replace the specified pattern in the source string with the replacement.<\/p>\n

Among them:<\/p>\n

    \n
  1. String to be replaced.<\/li>\n
  2. pattern: regular expression pattern used for matching.<\/li>\n
  3. replacement: substitute the matching part of the string.<\/li>\n<\/ol>\n

    Example of Usage:<\/p>\n

    SELECT<\/span> REGEXP_REPLACE('Hello World'<\/span>, 'o'<\/span>, 'u'<\/span>) FROM<\/span> dual;\r\n-- \u8f93\u51fa\uff1aHellu Wurld<\/span>\r\n\r\nSELECT<\/span> REGEXP_REPLACE('ABC123XYZ'<\/span>, '[A-Z]'<\/span>, ''<\/span>) FROM<\/span> dual;\r\n-- \u8f93\u51fa\uff1a123<\/span>\r\n\r\nSELECT<\/span> REGEXP_REPLACE('Hello123World'<\/span>, '\\d'<\/span>, ''<\/span>) FROM<\/span> dual;\r\n-- \u8f93\u51fa\uff1aHelloWorld<\/span>\r\n\r\nSELECT<\/span> REGEXP_REPLACE('ABC-123-XYZ'<\/span>, '(\\w+)-(\\d+)-(\\w+)'<\/span>, '\\3-\\2-\\1'<\/span>) FROM<\/span> dual;\r\n-- \u8f93\u51fa\uff1aXYZ-123-ABC<\/span>\r\n<\/code><\/pre>\n
    In the examples above, the first statement replaces the letter ‘o’ in the string with ‘u’. The second statement replaces uppercase letters in the string with an empty string. The third statement replaces numbers in the string with an empty string. Lastly, the final statement uses grouping captures and rearranges the matching parts in a specified order.<\/p>\n","protected":false},"excerpt":{"rendered":"
    The REGEXP_REPLACE function in Oracle is used to replace parts of a string that match a specified pattern. Its syntax is as follows: Replace the specified pattern in the source string with the replacement. Among them: String to be replaced. pattern: regular expression pattern used for matching. replacement: substitute the matching part of the string. […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[766,472,1992,1803,1115],"class_list":["post-13626","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-queries","tag-oracle-sql","tag-pattern-matching","tag-regular-expressions","tag-string-functions"],"yoast_head":"\nOracle REGEXP_REPLACE Function Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use Oracle's REGEXP_REPLACE function for pattern matching and string replacement with syntax examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle REGEXP_REPLACE Function Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Oracle's REGEXP_REPLACE function for pattern matching and string replacement with syntax examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T07:31:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T21:14:20+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"Oracle REGEXP_REPLACE Function Guide\",\"datePublished\":\"2024-03-15T07:31:14+00:00\",\"dateModified\":\"2025-08-05T21:14:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\"},\"wordCount\":121,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Database Queries\",\"Oracle SQL\",\"pattern matching\",\"regular expressions\",\"string functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\",\"name\":\"Oracle REGEXP_REPLACE Function Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:31:14+00:00\",\"dateModified\":\"2025-08-05T21:14:20+00:00\",\"description\":\"Learn how to use Oracle's REGEXP_REPLACE function for pattern matching and string replacement with syntax examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle REGEXP_REPLACE Function Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle REGEXP_REPLACE Function Guide - Blog - Silicon Cloud","description":"Learn how to use Oracle's REGEXP_REPLACE function for pattern matching and string replacement with syntax examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Oracle REGEXP_REPLACE Function Guide","og_description":"Learn how to use Oracle's REGEXP_REPLACE function for pattern matching and string replacement with syntax examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:31:14+00:00","article_modified_time":"2025-08-05T21:14:20+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"Oracle REGEXP_REPLACE Function Guide","datePublished":"2024-03-15T07:31:14+00:00","dateModified":"2025-08-05T21:14:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/"},"wordCount":121,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Database Queries","Oracle SQL","pattern matching","regular expressions","string functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/","name":"Oracle REGEXP_REPLACE Function Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:31:14+00:00","dateModified":"2025-08-05T21:14:20+00:00","description":"Learn how to use Oracle's REGEXP_REPLACE function for pattern matching and string replacement with syntax examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-is-the-regexp_replace-function-used-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle REGEXP_REPLACE Function Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13626"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13626\/revisions"}],"predecessor-version":[{"id":157627,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13626\/revisions\/157627"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}