{"type":"rich","published":"2023-02-18 23:34:31","author_url":"https://blog.hatena.ne.jp/HTN20190109/","provider_name":"Hatena Blog","categories":["DB"],"url":"https://htn20190109.hatenablog.com/entry/2023/02/18/233431","provider_url":"https://hatena.blog","image_url":null,"height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2023%2F02%2F18%2F233431\" title=\"pivot\u53e5\u306b\u3088\u308b\u30af\u30ed\u30b9\u96c6\u8a08 - 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>","version":"1.0","blog_url":"https://htn20190109.hatenablog.com/","blog_title":"HTN20190109\u306e\u65e5\u8a18","description":"MySQL (8.0.31) pivot\u53e5\u306f\u4f7f\u7528\u3067\u304d\u306a\u3044\u305f\u3081\u3001case\u53e5\u3067\u4ee3\u7528 Oracle (19c) https://style.potepan.com/articles/25072.htmlhttps://oraclesqlpuzzle.ninja-web.net/oracle-sql-image/oracle-sql-image08.html -- 1. \u30c6\u30b9\u30c8\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210 drop table tab1 purge; create table tab1(salemonth varchar2(6),productname varchar2(10),amount int); -- 2. \u2026","title":"pivot\u53e5\u306b\u3088\u308b\u30af\u30ed\u30b9\u96c6\u8a08","author_name":"HTN20190109","width":"100%"}