Auf<\/p>\n
https:\/\/blogs.oracle.com\/aramamoo\/how-to-split-comma-separated-string-and-pass-to-in-clause-of-select-statement<\/p>\n
wird erkl\u00e4rt, wie man in einer WHERE … IN Klausel eine String-Variable nutzen kann.<\/p>\n
Ein noch besseres Beispiel funktioniert so:<\/p>\n
with test as
\n(select ‚KART,KART-SPG,PAL‘ col from dual)
\nselect regexp_substr(col, ‚[^,]+‘, 1, level) result from test
\nconnect by level <= length(regexp_replace(col, ‚[^,]+‘)) + 1;<\/p>\n
.. liefert eine Tabelle zur\u00fcck und darum funktioniert dieser Ausdruck innerhalb einer WHERE-Klausel.<\/p>\n","protected":false},"excerpt":{"rendered":"
Auf https:\/\/blogs.oracle.com\/aramamoo\/how-to-split-comma-separated-string-and-pass-to-in-clause-of-select-statement wird erkl\u00e4rt, wie man in einer WHERE … IN Klausel eine String-Variable nutzen kann. Ein noch besseres Beispiel funktioniert so: with test as (select ‚KART,KART-SPG,PAL‘ col from dual) select regexp_substr(col, ‚[^,]+‘, 1, level) …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,2,4,3],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-heute-gelernt","category-oracle","category-plsql","category-sql"],"_links":{"self":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=62"}],"version-history":[{"count":3,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":65,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions\/65"}],"wp:attachment":[{"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mein-it-wissen.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}