{"categories":["DB","ORACLE","SCRAP"],"author_name":"winebarrel","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/winebarrel/","blog_title":"so what","version":"1.0","description":"\u30ab\u30fc\u30bd\u30eb\u3002 set serveroutput on;declare cursor c_sess is select V_SESS.SADDR from V$SESSION V_SESS; r_sess c_sess%rowtype; begin open c_sess; loop fetch c_sess into r_sess; exit when c_sess%notfound; DBMS_OUTPUT.PUT_LINE(r_sess.saddr); end loop; close c_sess; end; / 54288410 54288D78 542896E0 5428A048 542\u2026","url":"https://so-wh.at/entry/20050121/p1","height":"190","provider_url":"https://hatena.blog","width":"100%","title":" \u30ab\u30fc\u30bd\u30eb\u306e\u30b9\u30af\u30e9\u30c3\u30d7\u3002","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fso-wh.at%2Fentry%2F20050121%2Fp1\" title=\" \u30ab\u30fc\u30bd\u30eb\u306e\u30b9\u30af\u30e9\u30c3\u30d7\u3002 - so what\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://so-wh.at/","published":"2005-01-21 00:00:02","image_url":null,"type":"rich"}