{"id":933,"date":"2017-03-14T19:37:54","date_gmt":"2017-03-14T19:37:54","guid":{"rendered":"http:\/\/blog.tiran.info\/?p=933"},"modified":"2017-03-14T19:37:54","modified_gmt":"2017-03-14T19:37:54","slug":"methode-de-monte-carlo-en-sql","status":"publish","type":"post","link":"https:\/\/blog.tiran.stream\/?p=933","title":{"rendered":"M\u00e9thode de Monte-Carlo en SQL"},"content":{"rendered":"<p style=\"text-align: justify;\">Aujourd&rsquo;hui 14 Mars &#8211; ou 3\/14 avec un format de date am\u00e9ricain &#8211; c&rsquo;est <a href=\"http:\/\/www.francetvinfo.fr\/sciences\/video-l-histoire-du-nombre-pi-fete-chaque-14-mars-racontee-en-trois-minutes-et-demi_2097025.html\" target=\"_blank\">le Pi-Day<\/a> !<\/p>\n<p style=\"text-align: justify;\">Pour l&rsquo;occasion, de nombreux <a href=\"https:\/\/connormcdonald.wordpress.com\/2017\/03\/15\/pi-day-march-14\/\" target=\"_blank\">blogs Oracle<\/a> indiquent des m\u00e9thodes pour calculer une approximation de Pi en SQL.<\/p>\n<p style=\"text-align: justify;\">Et voici ma contribution \u00e0 ce sujet primordial \ud83d\ude42 avec un calcul bas\u00e9\u00a0une <a href=\"https:\/\/fr.wikipedia.org\/wiki\/M%C3%A9thode_de_Monte-Carlo\" target=\"_blank\">m\u00e9thode Monte-Carlo<\/a>:<\/p>\n<pre class=\"brush: sql; ruler: true;\">SQL&gt; select to_char(sysdate,&#039;MM.DD&#039;) Pi from dual;\n\nPI\n-----\n03.14\n\nSQL&gt; WITH space\n  2       AS (    SELECT POWER (DBMS_RANDOM.VALUE, 2) + POWER (DBMS_RANDOM.VALUE, 2)\n  3                          in_circle\n  4                 FROM DUAL\n  5           CONNECT BY LEVEL &lt; 1e7)\n  6  SELECT 4 * (COUNT (*) \/ 1e7) Pi\n  7    FROM space\n  8   WHERE in_circle &lt;= 1;\n\n        PI\n----------\n 3.1415852\n\nSQL&gt;\n<\/pre>\n<p style=\"text-align: justify;\">Pas tr\u00e8s pr\u00e9cis, pas tr\u00e8s rapide mais bon&#8230;<br \/>\n\ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aujourd&rsquo;hui 14 Mars &#8211; ou 3\/14 avec un format de date am\u00e9ricain &#8211; c&rsquo;est le Pi-Day ! Pour l&rsquo;occasion, de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[6,11],"tags":[],"class_list":["post-933","post","type-post","status-publish","format-standard","hentry","category-oracle","category-probabilites"],"_links":{"self":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts\/933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=933"}],"version-history":[{"count":0,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=\/wp\/v2\/posts\/933\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tiran.stream\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}