(window.webpackJsonp=window.webpackJsonp||[]).push([[2356],{2764:function(e,s,a){"use strict";a.r(s);var r=a(31),t=Object(r.a)({},(function(){var e=this,s=e.$createElement,a=e._self._c||s;return a("ContentSlotsDistributor",{attrs:{"slot-key":e.$parent.slotKey}},[a("h1",{attrs:{id:"level-query"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#level-query"}},[e._v("#")]),e._v(" level query")]),e._v(" "),a("h2",{attrs:{id:"generate-n-number-of-records"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#generate-n-number-of-records"}},[e._v("#")]),e._v(" Generate N Number of records")]),e._v(" "),a("div",{staticClass:"language-sql extra-class"},[a("pre",{pre:!0,attrs:{class:"language-sql"}},[a("code",[a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("SELECT")]),e._v(" ROWNUM "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("NO")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("FROM")]),e._v(" DUAL "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("CONNECT")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("BY")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("LEVEL")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[e._v("<=")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[e._v("10")]),e._v("\n\n")])])]),a("h2",{attrs:{id:"few-usages-of-level-query"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#few-usages-of-level-query"}},[e._v("#")]),e._v(" Few usages of Level Query")]),e._v(" "),a("p",[e._v("/* This is a simple query which can generate a sequence of numbers. The following example generates a sequence of numbers from 1..100 */")]),e._v(" "),a("div",{staticClass:"language-sql extra-class"},[a("pre",{pre:!0,attrs:{class:"language-sql"}},[a("code",[a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("select")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("level")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("from")]),e._v(" dual "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("connect")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("by")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("level")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[e._v("<=")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[e._v("100")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[e._v(";")]),e._v("\n\n")])])]),a("p",[e._v("/*The above query is useful in various scenarios like generating a sequence of dates from a given date. The following query generates 10 consecutive dates */")]),e._v(" "),a("div",{staticClass:"language-sql extra-class"},[a("pre",{pre:!0,attrs:{class:"language-sql"}},[a("code",[a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("select")]),e._v(" to_date"),a("span",{pre:!0,attrs:{class:"token punctuation"}},[e._v("(")]),a("span",{pre:!0,attrs:{class:"token string"}},[e._v("'01-01-2017'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[e._v(",")]),a("span",{pre:!0,attrs:{class:"token string"}},[e._v("'mm-dd-yyyy'")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[e._v(")")]),a("span",{pre:!0,attrs:{class:"token operator"}},[e._v("+")]),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("level")]),a("span",{pre:!0,attrs:{class:"token operator"}},[e._v("-")]),a("span",{pre:!0,attrs:{class:"token number"}},[e._v("1")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("as")]),e._v("  dates "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("from")]),e._v(" dual "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("connect")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("by")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token keyword"}},[e._v("level")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token operator"}},[e._v("<=")]),e._v(" "),a("span",{pre:!0,attrs:{class:"token number"}},[e._v("10")]),a("span",{pre:!0,attrs:{class:"token punctuation"}},[e._v(";")]),e._v("\n\n")])])]),a("p",[e._v("01-JAN-17"),a("br"),e._v("\n02-JAN-17"),a("br"),e._v("\n03-JAN-17"),a("br"),e._v("\n04-JAN-17"),a("br"),e._v("\n05-JAN-17"),a("br"),e._v("\n06-JAN-17"),a("br"),e._v("\n07-JAN-17"),a("br"),e._v("\n08-JAN-17"),a("br"),e._v("\n09-JAN-17"),a("br"),e._v("\n10-JAN-17"),a("br")]),e._v(" "),a("h4",{attrs:{id:"remarks"}},[a("a",{staticClass:"header-anchor",attrs:{href:"#remarks"}},[e._v("#")]),e._v(" Remarks")]),e._v(" "),a("p",[e._v("level clause is responsible for generating N number of dummy records based on some specific condition.")])])}),[],!1,null,null,null);s.default=t.exports}}]);