{"id":283,"date":"2008-09-03T13:42:33","date_gmt":"2008-09-03T11:42:33","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=283"},"modified":"2016-01-21T13:28:47","modified_gmt":"2016-01-21T11:28:47","slug":"sprawdzenie-czy-kurs-dzienny-jest-prawidlowo-wprowadzony","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=283","title":{"rendered":"Sprawdzenie czy kurs dzienny jest prawid\u0142owo wprowadzony"},"content":{"rendered":"<p>Przeznaczenie discoverer &#8211; logistyka<\/p>\n<pre lang='PLSQL'>\r\nselect t.conversion_date,\r\n conversion_rate \"Jest\",\r\n t.inverse_conversion_rate,\r\n 1 \/ t.inverse_conversion_rate \"Powinno by\u0107\"\r\n from apps.gl_daily_rates_v t\r\n where user_conversion_type = 'NBP'\r\n and from_currency = 'PLN'\r\n and to_currency = 'EUR'\r\n and t.conversion_rate not in\r\n (select 1 \/ t1.inverse_conversion_rate\r\n from apps.gl_daily_rates_v t1\r\n where user_conversion_type = 'NBP'\r\n and from_currency = 'PLN'\r\n and to_currency = 'EUR')<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Przeznaczenie discoverer &#8211; logistyka select t.conversion_date, conversion_rate &#8222;Jest&#8221;, t.inverse_conversion_rate, 1 \/ t.inverse_conversion_rate &#8222;Powinno by\u0107&#8221; from apps.gl_daily_rates_v t where user_conversion_type = 'NBP&#8217; and from_currency = 'PLN&#8217; and to_currency = 'EUR&#8217; and t.conversion_rate not in (select 1 \/ t1.inverse_conversion_rate from apps.gl_daily_rates_v t1 &hellip; <a href=\"http:\/\/oracle.malin.pl\/?p=283\">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":[35],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/283"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=283"}],"version-history":[{"count":2,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":1214,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/283\/revisions\/1214"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}