{"id":18753,"date":"2024-03-15T17:34:30","date_gmt":"2024-03-15T17:34:30","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/"},"modified":"2024-03-21T14:03:44","modified_gmt":"2024-03-21T14:03:44","slug":"how-to-extract-and-sort-a-string-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/","title":{"rendered":"How to extract and sort a string in Oracle?"},"content":{"rendered":"<p>To extract and sort an Oracle string, you can use the SUBSTR function and ORDER BY clause.<\/p>\n<p>Firstly, use the SUBSTR function to extract a portion of the string. The syntax for the SUBSTR function is:<\/p>\n<pre class=\"post-pre\"><code>SUBSTR(\u5b57\u7b26\u4e32, \u8d77\u59cb\u4f4d\u7f6e, \u622a\u53d6\u957f\u5ea6)\r\n<\/code><\/pre>\n<p>Among them, the string is the substring to be taken, the starting position is the position where the extraction should begin, and the extraction length is the number of characters to be extracted.<\/p>\n<p>Next, sort the truncated strings using the ORDER BY clause. The syntax for the ORDER BY clause is:<\/p>\n<pre class=\"post-pre\"><code>ORDER BY \u5217\u540d [ASC|DESC]\r\n<\/code><\/pre>\n<p>The column name is the name of the column to be sorted, with ASC indicating ascending order and DESC indicating descending order.<\/p>\n<p>Here is an example:<\/p>\n<p>Suppose there is a table named &#8220;employees&#8221; with a column called &#8220;full_name&#8221; storing employees&#8217; full names. To extract and sort them by last name, you can use the following SQL statement:<\/p>\n<pre class=\"post-pre\"><code>SELECT SUBSTR(full_name, INSTR(full_name, ' ')+1) AS last_name\r\nFROM employees\r\nORDER BY last_name;\r\n<\/code><\/pre>\n<p>In this example, the SUBSTR function is used in conjunction with the INSTR function to extract the surname part. The syntax of the INSTR function is:<\/p>\n<pre class=\"post-pre\"><code>INSTR(\u5b57\u7b26\u4e32, \u67e5\u627e\u5b57\u7b26\u4e32)\r\n<\/code><\/pre>\n<p>In this case, the string refers to the string being searched, and the search string is the substring to be found within the string. The INSTR function returns the position of the first occurrence of the search string within the string.<\/p>\n<p>Next, use the SELECT clause to choose the last name part to display and alias it as &#8220;last_name&#8221;. Finally, use the ORDER BY clause to sort by last name.<\/p>\n<p>You can adjust the table name, column name, and extraction position in the above SQL query according to specific requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To extract and sort an Oracle string, you can use the SUBSTR function and ORDER BY clause. Firstly, use the SUBSTR function to extract a portion of the string. The syntax for the SUBSTR function is: SUBSTR(\u5b57\u7b26\u4e32, \u8d77\u59cb\u4f4d\u7f6e, \u622a\u53d6\u957f\u5ea6) Among them, the string is the substring to be taken, the starting position is the position [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-18753","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"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>How to extract and sort a string in Oracle? - Blog - Silicon Cloud<\/title>\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-to-extract-and-sort-a-string-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to extract and sort a string in Oracle?\" \/>\n<meta property=\"og:description\" content=\"To extract and sort an Oracle string, you can use the SUBSTR function and ORDER BY clause. Firstly, use the SUBSTR function to extract a portion of the string. The syntax for the SUBSTR function is: SUBSTR(\u5b57\u7b26\u4e32, \u8d77\u59cb\u4f4d\u7f6e, \u622a\u53d6\u957f\u5ea6) Among them, the string is the substring to be taken, the starting position is the position [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-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-15T17:34:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T14:03: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-to-extract-and-sort-a-string-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How to extract and sort a string in Oracle?\",\"datePublished\":\"2024-03-15T17:34:30+00:00\",\"dateModified\":\"2024-03-21T14:03:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/\"},\"wordCount\":271,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/\",\"name\":\"How to extract and sort a string in Oracle? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T17:34:30+00:00\",\"dateModified\":\"2024-03-21T14:03:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to extract and sort a string in Oracle?\"}]},{\"@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":"How to extract and sort a string in Oracle? - Blog - Silicon Cloud","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-to-extract-and-sort-a-string-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How to extract and sort a string in Oracle?","og_description":"To extract and sort an Oracle string, you can use the SUBSTR function and ORDER BY clause. Firstly, use the SUBSTR function to extract a portion of the string. The syntax for the SUBSTR function is: SUBSTR(\u5b57\u7b26\u4e32, \u8d77\u59cb\u4f4d\u7f6e, \u622a\u53d6\u957f\u5ea6) Among them, the string is the substring to be taken, the starting position is the position [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T17:34:30+00:00","article_modified_time":"2024-03-21T14:03: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-to-extract-and-sort-a-string-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How to extract and sort a string in Oracle?","datePublished":"2024-03-15T17:34:30+00:00","dateModified":"2024-03-21T14:03:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/"},"wordCount":271,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/","name":"How to extract and sort a string in Oracle? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T17:34:30+00:00","dateModified":"2024-03-21T14:03:44+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-extract-and-sort-a-string-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to extract and sort a string in Oracle?"}]},{"@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\/18753","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=18753"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18753\/revisions"}],"predecessor-version":[{"id":52455,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18753\/revisions\/52455"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=18753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=18753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=18753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}