{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2023%2F03%2F29%2F002432\" title=\"{Denodo}\u30af\u30a8\u30ea\u6574\u5f62\u30b7\u30a7\u30eb - 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>","width":"100%","image_url":null,"blog_title":"HTN20190109\u306e\u65e5\u8a18","categories":["Denodo"],"published":"2023-03-29 00:24:32","provider_name":"Hatena Blog","title":"{Denodo}\u30af\u30a8\u30ea\u6574\u5f62\u30b7\u30a7\u30eb","blog_url":"https://htn20190109.hatenablog.com/","version":"1.0","provider_url":"https://hatena.blog","height":"190","author_name":"HTN20190109","description":"Oracle\u306e\u30cd\u30a4\u30c6\u30a3\u30d6\u30af\u30a8\u30ea\u3092Denodo\u3067\u52d5\u4f5c\u3059\u308b\u3088\u3046\u306b\u6574\u5f62\u3059\u308b X+\u30ab\u30e9\u30e0\u540d\uff0bY\u2193X+\"\u5927\u6587\u5b57\u30ab\u30e9\u30e0\u540d\"+Y X\u306f\u30b9\u30da\u30fc\u30b9\u3001\u30d4\u30ea\u30aa\u30c9Y\u306f\u30b9\u30da\u30fc\u30b9\u3001\u30ab\u30f3\u30de\u3001\u884c\u672b -- 1. \u4f7f\u7528\u30ab\u30e9\u30e0\u306e\u53d6\u5f97 \u4e8b\u524d\u5b9a\u7fa9\u306e\u30b9\u30c8\u30a2\u30c9\u3092\u4f7f\u7528\u3057\u3066\u30ab\u30e9\u30e0\u4e00\u89a7\u3092\u5927\u6587\u5b57\u3067\u53d6\u5f97\u3059\u308b select upper(column_name) from GET_VIEW_COLUMNS('db02','b_tab1'); -- 2. \u30b7\u30a7\u30eb \u30b7\u30a7\u30eb\u672c\u4f53: a.sh\u30ab\u30e9\u30e0\u4e00\u89a7: a.txt\u30af\u30a8\u30ea: a.sql vim a.txtCOL1COL2COL3COL4COL5COL6COL7 cat a.txt vim a.sql SELEC\u2026","author_url":"https://blog.hatena.ne.jp/HTN20190109/","url":"https://htn20190109.hatenablog.com/entry/2023/03/29/002432","type":"rich"}