{"id":1195,"date":"2015-12-11T12:17:35","date_gmt":"2015-12-11T10:17:35","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1195"},"modified":"2015-12-11T12:18:25","modified_gmt":"2015-12-11T10:18:25","slug":"sql-znaki-specjalne-w-bazie-danych","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1195","title":{"rendered":"SQL &#8211; znaki specjalne w bazie danych"},"content":{"rendered":"<p>SQL do wyszukania znak\u00f3w specjalnych.<\/p>\n<pre lang=\"PLSQL\">\r\nselect level,CHR(level),\r\n       decode(chr(level), regexp_substr(chr(level), '[[:graph:]]'), 1) is_graph,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:blank:]]'), 1) is_blank,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:alnum:]]'), 1) is_alnum,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:alpha:]]'), 1) is_alpha,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:digit:]]'), 1) is_digit,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:cntrl:]]'), 1) is_cntrl,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:lower:]]'), 1) is_lower,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:upper:]]'), 1) is_upper,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:print:]]'), 1) is_print,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:punct:]]'), 1) is_punct,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:space:]]'), 1) is_space,\r\n       decode(chr(level), regexp_substr(chr(level), '[[:xdigit:]]'), 1) is_xdigit\r\n  from dual\r\nconnect by level < = 300\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL do wyszukania znak\u00f3w specjalnych. select level,CHR(level), decode(chr(level), regexp_substr(chr(level), '[[:graph:]]&#8217;), 1) is_graph, decode(chr(level), regexp_substr(chr(level), '[[:blank:]]&#8217;), 1) is_blank, decode(chr(level), regexp_substr(chr(level), '[[:alnum:]]&#8217;), 1) is_alnum, decode(chr(level), regexp_substr(chr(level), '[[:alpha:]]&#8217;), 1) is_alpha, decode(chr(level), regexp_substr(chr(level), '[[:digit:]]&#8217;), 1) is_digit, decode(chr(level), regexp_substr(chr(level), '[[:cntrl:]]&#8217;), 1) is_cntrl, decode(chr(level), regexp_substr(chr(level), '[[:lower:]]&#8217;), &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1195\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[186],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1195"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1195"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1195\/revisions"}],"predecessor-version":[{"id":1197,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1195\/revisions\/1197"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}