{"id":14235,"date":"2024-03-15T08:43:13","date_gmt":"2024-03-15T08:43:13","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/"},"modified":"2025-08-06T05:51:30","modified_gmt":"2025-08-06T05:51:30","slug":"what-is-the-function-of-the-substr-function-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/","title":{"rendered":"Oracle SUBSTR Function Explained"},"content":{"rendered":"

In Oracle, the SUBSTR function is used to extract a substring from a string. It returns a part of a string, allowing you to specify both the starting position and the length to extract.<\/p>\n

The syntax of the SUBSTR function is as follows: SUBSTR(string, start_position, [length])<\/p>\n

Explanation of parameters:<\/p>\n

    \n
  1. String: the string to be extracted.<\/li>\n
  2. The starting position for the extraction. The position starts counting from 1, indicating the beginning of the string for the extraction.<\/li>\n
  3. Length: an optional parameter that specifies the desired length to be extracted. If this parameter is omitted, all characters from the starting position to the end of the string will be returned.<\/li>\n<\/ol>\n

    For example, assuming there is a string “Hello World”, the SUBSTR function can be used to achieve the following functionality:<\/p>\n

      \n
    1. The function SUBSTR(“Hello World”, 7) will return “World”, starting from the 7th character until the end.<\/li>\n
    2. Using SUBSTR(\u201cHello World\u201d, 7, 3) will return \u201cWor\u201d, which is a substring starting from the 7th character with a length of 3 characters.<\/li>\n<\/ol>\n

      It is important to note that both the starting position and length parameters of the SUBSTR function can be negative. Negative numbers indicate counting from the end of the string. For example, SUBSTR(“Hello World”, -3) returns “rld”, indicating to start extracting from the 3rd character from the end to the end.<\/p>\n","protected":false},"excerpt":{"rendered":"

      In Oracle, the SUBSTR function is used to extract a substring from a string. It returns a part of a string, allowing you to specify both the starting position and the length to extract. The syntax of the SUBSTR function is as follows: SUBSTR(string, start_position, [length]) Explanation of parameters: String: the string to be extracted. […]<\/p>\n","protected":false},"author":14,"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":[5038,7043,12141,16861,19175],"class_list":["post-14235","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-oracle-sql-functions","tag-oracle-substr","tag-sql-substring","tag-string-extraction","tag-substr-syntax"],"yoast_head":"\nOracle SUBSTR Function Explained - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Master Oracle SUBSTR function: extract substrings using start position & length. Syntax, parameters, and clear 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\/what-is-the-function-of-the-substr-function-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SUBSTR Function Explained\" \/>\n<meta property=\"og:description\" content=\"Master Oracle SUBSTR function: extract substrings using start position & length. Syntax, parameters, and clear examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-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-15T08:43:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T05:51:30+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\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=\"Noah Thompson\" \/>\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\/what-is-the-function-of-the-substr-function-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"Oracle SUBSTR Function Explained\",\"datePublished\":\"2024-03-15T08:43:13+00:00\",\"dateModified\":\"2025-08-06T05:51:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/\"},\"wordCount\":222,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Oracle SQL functions\",\"Oracle SUBSTR\",\"SQL substring\",\"string extraction\",\"SUBSTR syntax\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/\",\"name\":\"Oracle SUBSTR Function Explained - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T08:43:13+00:00\",\"dateModified\":\"2025-08-06T05:51:30+00:00\",\"description\":\"Master Oracle SUBSTR function: extract substrings using start position & length. Syntax, parameters, and clear examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle SUBSTR Function Explained\"}]},{\"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle SUBSTR Function Explained - Blog - Silicon Cloud","description":"Master Oracle SUBSTR function: extract substrings using start position & length. Syntax, parameters, and clear 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\/what-is-the-function-of-the-substr-function-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Oracle SUBSTR Function Explained","og_description":"Master Oracle SUBSTR function: extract substrings using start position & length. Syntax, parameters, and clear examples.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T08:43:13+00:00","article_modified_time":"2025-08-06T05:51:30+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"Oracle SUBSTR Function Explained","datePublished":"2024-03-15T08:43:13+00:00","dateModified":"2025-08-06T05:51:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/"},"wordCount":222,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Oracle SQL functions","Oracle SUBSTR","SQL substring","string extraction","SUBSTR syntax"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/","name":"Oracle SUBSTR Function Explained - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T08:43:13+00:00","dateModified":"2025-08-06T05:51:30+00:00","description":"Master Oracle SUBSTR function: extract substrings using start position & length. Syntax, parameters, and clear examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-the-substr-function-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle SUBSTR Function Explained"}]},{"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14235","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=14235"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14235\/revisions"}],"predecessor-version":[{"id":158259,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14235\/revisions\/158259"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}