{"id":27564,"date":"2022-12-25T04:48:41","date_gmt":"2022-12-24T23:18:41","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/"},"modified":"2022-12-25T04:48:41","modified_gmt":"2022-12-24T23:18:41","slug":"solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/","title":{"rendered":"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)?"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-44407693\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"44407693\" data-parentid=\"44407252\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p><strong>Oracle Setup<\/strong>:<\/p>\n<pre><code>CREATE your_table ( source, target ) AS\n  SELECT '0',     '1' FROM DUAL UNION ALL\n  SELECT '0',     '2' FROM DUAL UNION ALL\n  SELECT '0',     '3' FROM DUAL UNION ALL\n  SELECT '1',     '1.1' FROM DUAL UNION ALL\n  SELECT '1',     '1.2' FROM DUAL UNION ALL\n  SELECT '1',     '1.3' FROM DUAL UNION ALL\n  SELECT '2',     '2.1' FROM DUAL UNION ALL\n  SELECT '2',     '2.2' FROM DUAL UNION ALL\n  SELECT '3',     '3.1' FROM DUAL UNION ALL\n  SELECT '1.1',   '1.1.1' FROM DUAL UNION ALL\n  SELECT '1.1',   '1.1.2' FROM DUAL UNION ALL\n  SELECT '1.1',   '1.1.3' FROM DUAL UNION ALL\n  SELECT '1.1.2', '1.1.2.1' FROM DUAL UNION ALL\n  SELECT '1.1.2', '1.1.2.2' FROM DUAL UNION ALL\n  SELECT '1.1.2', '1.1.2.3' FROM DUAL;\n<\/code><\/pre>\n<p><strong>Query<\/strong>:<\/p>\n<pre><code>SELECT CONNECT_BY_ROOT( target ) AS first_child\nFROM   your_table\nWHERE  target=\"1.1.2.2\"\nSTART WITH source=\"0\"\nCONNECT BY PRIOR target = source;\n<\/code><\/pre>\n<p><strong>Output<\/strong>:<\/p>\n<pre><code>FIRST_CHILD\n-----------\n1\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How to use recursively to query get node after root one level (details see in the photo attach)? <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Oracle Setup: CREATE your_table ( source, target ) AS SELECT &#8216;0&#8217;, &#8216;1&#8217; FROM DUAL UNION ALL SELECT &#8216;0&#8217;, &#8216;2&#8217; FROM DUAL UNION ALL SELECT &#8216;0&#8217;, &#8216;3&#8217; FROM DUAL UNION ALL SELECT &#8216;1&#8217;, &#8216;1.1&#8217; FROM DUAL UNION ALL SELECT &#8216;1&#8217;, &#8216;1.2&#8217; FROM DUAL UNION ALL SELECT &#8216;1&#8217;, &#8216;1.3&#8217; FROM DUAL UNION ALL SELECT &#8216;2&#8217;, &#8216;2.1&#8217; &#8230; <a title=\"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\" aria-label=\"More on [Solved] How to use recursively to query get node after root one level (details see in the photo attach)?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[341],"class_list":["post-27564","post","type-post","status-publish","format-standard","hentry","category-solved","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How to use recursively to query get node after root one level (details see in the photo attach)? - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Oracle Setup: CREATE your_table ( source, target ) AS SELECT &#039;0&#039;, &#039;1&#039; FROM DUAL UNION ALL SELECT &#039;0&#039;, &#039;2&#039; FROM DUAL UNION ALL SELECT &#039;0&#039;, &#039;3&#039; FROM DUAL UNION ALL SELECT &#039;1&#039;, &#039;1.1&#039; FROM DUAL UNION ALL SELECT &#039;1&#039;, &#039;1.2&#039; FROM DUAL UNION ALL SELECT &#039;1&#039;, &#039;1.3&#039; FROM DUAL UNION ALL SELECT &#039;2&#039;, &#039;2.1&#039; ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-24T23:18:41+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)?\",\"datePublished\":\"2022-12-24T23:18:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\"},\"wordCount\":44,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\",\"name\":\"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-24T23:18:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)? - JassWeb","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:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)? - JassWeb","og_description":"[ad_1] Oracle Setup: CREATE your_table ( source, target ) AS SELECT '0', '1' FROM DUAL UNION ALL SELECT '0', '2' FROM DUAL UNION ALL SELECT '0', '3' FROM DUAL UNION ALL SELECT '1', '1.1' FROM DUAL UNION ALL SELECT '1', '1.2' FROM DUAL UNION ALL SELECT '1', '1.3' FROM DUAL UNION ALL SELECT '2', '2.1' ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/","og_site_name":"JassWeb","article_published_time":"2022-12-24T23:18:41+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)?","datePublished":"2022-12-24T23:18:41+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/"},"wordCount":44,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/","name":"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-24T23:18:41+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-use-recursively-to-query-get-node-after-root-one-level-details-see-in-the-photo-attach\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to use recursively to query get node after root one level (details see in the photo attach)?"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/27564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=27564"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/27564\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=27564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=27564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=27564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}