{"id":4093,"date":"2024-03-13T07:55:47","date_gmt":"2024-03-13T07:55:47","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/"},"modified":"2025-07-31T01:30:44","modified_gmt":"2025-07-31T01:30:44","slug":"how-can-oracle-extract-the-last-two-characters-from-a-string","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/","title":{"rendered":"Oracle Extract Last Two Characters"},"content":{"rendered":"<p>To extract the last two characters of a string, you can use the SUBSTR function and the LENGTH function. Here is an example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> SUBSTR(<span class=\"hljs-string\">'YourString'<\/span>, LENGTH(<span class=\"hljs-string\">'YourString'<\/span>) <span class=\"hljs-operator\">-<\/span> <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">2<\/span>) <span class=\"hljs-keyword\">FROM<\/span> dual;\r\n<\/code><\/pre>\n<p>In the code above, &#8216;YourString&#8217; is the string you want to extract. The SUBSTR function is used to extract the last two characters of the string. The LENGTH function is used to get the length of the string, then subtract 1 to get the position of the second to last character.<\/p>\n<p>You can replace &#8216;YourString&#8217; in the code above with the specific string you want to extract, and then execute the SQL statement to get the result.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To extract the last two characters of a string, you can use the SUBSTR function and the LENGTH function. Here is an example: SELECT SUBSTR(&#8216;YourString&#8217;, LENGTH(&#8216;YourString&#8217;) &#8211; 1, 2) FROM dual; In the code above, &#8216;YourString&#8217; is the string you want to extract. The SUBSTR function is used to extract the last two characters of [&hellip;]<\/p>\n","protected":false},"author":10,"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":[813,472,3290,276,3289],"class_list":["post-4093","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-oracle-database","tag-oracle-sql","tag-sql-string-functions","tag-string-manipulation","tag-substr-function"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Extract Last Two Characters - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to extract last two characters in Oracle using SUBSTR and LENGTH functions with SQL 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-can-oracle-extract-the-last-two-characters-from-a-string\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Extract Last Two Characters\" \/>\n<meta property=\"og:description\" content=\"Learn how to extract last two characters in Oracle using SUBSTR and LENGTH functions with SQL examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-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-13T07:55:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T01:30:44+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\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=\"Jackson Davis\" \/>\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-can-oracle-extract-the-last-two-characters-from-a-string\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"Oracle Extract Last Two Characters\",\"datePublished\":\"2024-03-13T07:55:47+00:00\",\"dateModified\":\"2025-07-31T01:30:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/\"},\"wordCount\":104,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Oracle database\",\"Oracle SQL\",\"SQL string functions\",\"string manipulation\",\"SUBSTR function\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/\",\"name\":\"Oracle Extract Last Two Characters - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-13T07:55:47+00:00\",\"dateModified\":\"2025-07-31T01:30:44+00:00\",\"description\":\"Learn how to extract last two characters in Oracle using SUBSTR and LENGTH functions with SQL examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Extract Last Two Characters\"}]},{\"@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\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Extract Last Two Characters - Blog - Silicon Cloud","description":"Learn how to extract last two characters in Oracle using SUBSTR and LENGTH functions with SQL 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-can-oracle-extract-the-last-two-characters-from-a-string\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Extract Last Two Characters","og_description":"Learn how to extract last two characters in Oracle using SUBSTR and LENGTH functions with SQL examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-13T07:55:47+00:00","article_modified_time":"2025-07-31T01:30:44+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"Oracle Extract Last Two Characters","datePublished":"2024-03-13T07:55:47+00:00","dateModified":"2025-07-31T01:30:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/"},"wordCount":104,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Oracle database","Oracle SQL","SQL string functions","string manipulation","SUBSTR function"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/","name":"Oracle Extract Last Two Characters - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-13T07:55:47+00:00","dateModified":"2025-07-31T01:30:44+00:00","description":"Learn how to extract last two characters in Oracle using SUBSTR and LENGTH functions with SQL examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-extract-the-last-two-characters-from-a-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Extract Last Two Characters"}]},{"@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\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4093","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4093"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4093\/revisions"}],"predecessor-version":[{"id":148754,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4093\/revisions\/148754"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}