Ein kleines Beispiel mit with clause unterst\u00fctzt den Einsatz in der Praxis.
\nMit Views aus der with clause lassen sich Daten lesen, berechnen und stehen weiteren Whith-Clause Views oder der Hauptabfrage zur Verf\u00fcgung.<\/p>\n
Das folgende Beispiel l\u00e4sst sich in einer Oracle Datenbank ausf\u00fchren. View 2 und View 3\u00a0dienen zur Veranschaulichung wie mehrere Views vordefiniert werden k\u00f6nnen.<\/p>\n
with v1_heute as ( \r\n--------------------------------------------------------------------------------------------------------------------------------\r\n-- View 1\r\n--\r\n\u00a0\u00a0 select sysdate heute \r\n\u00a0\u00a0\u00a0\u00a0 from dual )\r\n--------------------------------------------------------------------------------------------------------------------------------\r\n-- View 2\r\n--\u00a0\u00a0\u00a0\u00a0 \r\n\u00a0, v2_gestern as ( \r\n\u00a0\u00a0 select sysdate -1 gestern \r\n\u00a0\u00a0\u00a0\u00a0 from dual)\r\n--------------------------------------------------------------------------------------------------------------------------------\r\n-- View 3\r\n--\u00a0\u00a0\u00a0\u00a0 \r\n\u00a0, v3_morgen as (\r\n\u00a0\u00a0 select sysdate + 1 morgen\r\n\u00a0\u00a0 from dual )\r\n--------------------------------------------------------------------------------------------------------------------------------\r\n-- Select Statment\r\n--\u00a0\u00a0\u00a0\u00a0 \r\nselect 'Morgen' Name\r\n\u00a0\u00a0\u00a0\u00a0 , to_char(morgen, 'Day') \r\n\u00a0\u00a0\u00a0\u00a0 , morgen tag \r\n\u00a0 from v3_morgen\r\nunion all\r\nselect 'Heute'\r\n\u00a0\u00a0\u00a0\u00a0 , to_char(heute, 'Day') \r\n\u00a0\u00a0\u00a0\u00a0 , heute \r\n\u00a0 from v1_heute\r\nunion all \r\nselect 'Gestern'\r\n\u00a0\u00a0\u00a0\u00a0 , to_char(gestern, 'Day') \r\n\u00a0\u00a0\u00a0\u00a0 , gestern \r\n\u00a0 from v2_gestern\r\norder by 3;<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Ein kleines Beispiel mit with clause unterst\u00fctzt den Einsatz in der Praxis. Mit Views aus der with clause lassen sich Daten lesen, berechnen und stehen weiteren Whith-Clause Views oder der Hauptabfrage zur Verf\u00fcgung. Das folgende Beispiel l\u00e4sst sich in einer Oracle Datenbank ausf\u00fchren. View 2 und View 3\u00a0dienen zur Veranschaulichung wie mehrere Views vordefiniert werden … <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[21,20],"class_list":["post-94","post","type-post","status-publish","format-standard","hentry","category-sql","tag-view","tag-with"],"_links":{"self":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94"}],"version-history":[{"count":5,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions"}],"predecessor-version":[{"id":130,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=\/wp\/v2\/posts\/94\/revisions\/130"}],"wp:attachment":[{"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pastscho.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}