{"width":"100%","categories":["DB"],"author_url":"https://blog.hatena.ne.jp/HTN20190109/","image_url":null,"title":"\u30d6\u30ed\u30c3\u30af\u756a\u53f7\u78ba\u8a8d","blog_url":"https://htn20190109.hatenablog.com/","version":"1.0","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2021%2F10%2F08%2F055913\" title=\"\u30d6\u30ed\u30c3\u30af\u756a\u53f7\u78ba\u8a8d - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","height":"190","published":"2021-10-08 05:59:13","author_name":"HTN20190109","blog_title":"HTN20190109\u306e\u65e5\u8a18","description":"MySQL (8.0.22) \u8abf\u3079\u305f\u9650\u308a\u65b9\u6cd5\u306a\u3057 Oracle (19c) drop table tab1 purge;create table tab1(col1 int,col2 varchar2(2000)); declarebeginfor i in 1..1000 loop insert into tab1 values(i,rpad('X',2000,'X')); commit;end loop;end;/ select col1,dbms_rowid.rowid_to_absolute_fno(rowid, 'TEST', 'TAB1') file_id,dbms_rowid.r\u2026","url":"https://htn20190109.hatenablog.com/entry/2021/10/08/055913","type":"rich"}