{"id":14222,"date":"2024-03-15T08:41:58","date_gmt":"2024-03-15T08:41:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/"},"modified":"2025-08-06T05:40:26","modified_gmt":"2025-08-06T05:40:26","slug":"the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/","title":{"rendered":"Oracle SUBSTR Function Guide"},"content":{"rendered":"

In Oracle, you can use the SUBSTR function to extract a substring. The syntax for the SUBSTR function is as follows:<\/p>\n

Extract a substring from the specified string, starting at a certain position and with a certain length.<\/p>\n

In this case, the string represents the original string to be extracted, the start position indicates from which point in the original string to begin extracting, and the length indicates the length of the substring to be extracted.<\/p>\n

Here are some examples:<\/p>\n

    \n
  1. Extract the first 3 characters from the string:
    \nSELECT SUBSTR(‘Hello World’, 1, 3) FROM dual;
    \nResult: Hel<\/li>\n
  2. Retrieve the characters from the 4th to the 7th position in the string:
    \nSELECT SUBSTR(‘Hello World’, 4, 4) FROM dual;
    \nResult: lo W<\/li>\n
  3. Extract the last 5 characters of a string:
    \nSELECT SUBSTR(‘Hello World’, -5) FROM dual;
    \nResult: World<\/li>\n<\/ol>\n

    Please note that the starting position can be negative, indicating counting from the end of the string. If the length parameter is omitted, it defaults to cutting all characters from the starting position to the end of the string.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In Oracle, you can use the SUBSTR function to extract a substring. The syntax for the SUBSTR function is as follows: Extract a substring from the specified string, starting at a certain position and with a certain length. In this case, the string represents the original string to be extracted, the start position indicates from […]<\/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":[19160,3301,7043,12141,8430],"class_list":["post-14222","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-oracle-data-extraction","tag-oracle-string-functions","tag-oracle-substr","tag-sql-substring","tag-substring-function"],"yoast_head":"\nOracle SUBSTR Function Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn syntax & examples for Oracle SUBSTR to extract substrings efficiently. Master string manipulation now.\" \/>\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\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SUBSTR Function Guide\" \/>\n<meta property=\"og:description\" content=\"Learn syntax & examples for Oracle SUBSTR to extract substrings efficiently. Master string manipulation now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\" \/>\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-15T08:41:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T05:40:26+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\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"Oracle SUBSTR Function Guide\",\"datePublished\":\"2024-03-15T08:41:58+00:00\",\"dateModified\":\"2025-08-06T05:40:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\"},\"wordCount\":176,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Oracle data extraction\",\"Oracle string functions\",\"Oracle SUBSTR\",\"SQL substring\",\"SUBSTRING function\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\",\"name\":\"Oracle SUBSTR Function Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T08:41:58+00:00\",\"dateModified\":\"2025-08-06T05:40:26+00:00\",\"description\":\"Learn syntax & examples for Oracle SUBSTR to extract substrings efficiently. Master string manipulation now.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle SUBSTR 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 SUBSTR Function Guide - Blog - Silicon Cloud","description":"Learn syntax & examples for Oracle SUBSTR to extract substrings efficiently. Master string manipulation now.","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\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/","og_locale":"en_US","og_type":"article","og_title":"Oracle SUBSTR Function Guide","og_description":"Learn syntax & examples for Oracle SUBSTR to extract substrings efficiently. Master string manipulation now.","og_url":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T08:41:58+00:00","article_modified_time":"2025-08-06T05:40:26+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\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"Oracle SUBSTR Function Guide","datePublished":"2024-03-15T08:41:58+00:00","dateModified":"2025-08-06T05:40:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/"},"wordCount":176,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Oracle data extraction","Oracle string functions","Oracle SUBSTR","SQL substring","SUBSTRING function"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/","url":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/","name":"Oracle SUBSTR Function Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T08:41:58+00:00","dateModified":"2025-08-06T05:40:26+00:00","description":"Learn syntax & examples for Oracle SUBSTR to extract substrings efficiently. Master string manipulation now.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/the-substr-function-in-oracle-is-used-to-extract-a-portion-of-a-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle SUBSTR 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\/14222","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=14222"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14222\/revisions"}],"predecessor-version":[{"id":158246,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14222\/revisions\/158246"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}