{"id":19,"date":"2011-07-19T12:19:39","date_gmt":"2011-07-19T11:19:39","guid":{"rendered":"http:\/\/www.hman-projects.de\/?p=19"},"modified":"2011-07-19T12:21:35","modified_gmt":"2011-07-19T11:21:35","slug":"19","status":"publish","type":"post","link":"https:\/\/www.hman-projects.de\/?p=19","title":{"rendered":"SQL &#8211; Like-Suche nach Wildcard-Zeichen unter Oracle"},"content":{"rendered":"<div>Aktuell werden auch schon teilweise REGEX-Funktionen in Datenbanken etabliert.<\/div>\n<div>Oftmals reicht aber eine einfache Suche mit vorgegebenen Mustern<\/div>\n<div><\/div>\n<div>Select * from Mitarbeiter<br \/>\nwhere nachname like \u2018H%mann\u2018;<\/div>\n<div><\/div>\n<div>Liefert Heinemann, Heynemann und auch Hoffmann<\/div>\n<div>Select * from Mitarbeiter<br \/>\nwhere nachname like \u2018He_nemann\u2018;<\/div>\n<div>Liefert nur Heinemann, Heynemann<\/div>\n<div>Zum ignorieren von Klein \u2013 und Gro\u00dfschrift kann man beides klein setzen<\/div>\n<div>Select * from Mitarbeiter where lower(nachname) like lower(\u2018He_nemann\u2018);<\/div>\n<div>Escape-Zeichen erm\u00f6glichen die Suche von Datens\u00e4tzen, die einen eigentlichen Wildcard enthalten.<br \/>\nDie nachfolgende Suche liefert alle Tabelle, die auch ein &#8222;_\u201d enthalten:<\/div>\n<div>Select * from all_tables<br \/>\nwhere table_name like &#8218;%\\_%&#8216; ESCAPE &#8218;\\&#8216;<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Aktuell werden auch schon teilweise REGEX-Funktionen in Datenbanken etabliert. Oftmals reicht aber eine einfache Suche mit vorgegebenen Mustern Select * from Mitarbeiter where nachname like \u2018H%mann\u2018; Liefert Heinemann, Heynemann und auch Hoffmann Select * from Mitarbeiter where nachname like \u2018He_nemann\u2018; Liefert nur Heinemann, Heynemann Zum ignorieren von Klein \u2013 und Gro\u00dfschrift kann man beides klein [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-oracle-sql"],"_links":{"self":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts\/19"}],"collection":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":5,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":21,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions\/21"}],"wp:attachment":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}