{"id":5,"date":"2014-10-01T05:03:54","date_gmt":"2014-10-01T05:03:54","guid":{"rendered":"http:\/\/www.hadooh.com\/?p=5"},"modified":"2014-10-25T09:29:00","modified_gmt":"2014-10-25T09:29:00","slug":"%ed%85%8c%ec%9d%b4%eb%b8%94%ec%9d%98-%ea%b8%b0%eb%b3%b8%ed%82%a4%ec%99%80-%ec%bd%94%eb%a9%98%ed%8a%b8-%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.hadooh.com\/?p=5","title":{"rendered":"\ud14c\uc774\ube14\uc758 \uae30\ubcf8\ud0a4\uc640 \ucf54\uba58\ud2b8 \ubcf4\uae30"},"content":{"rendered":"<p>SELECT TABLE_NAME, MAX(COMMENTS) AS TAB_COMMENTS, WM_CONCAT(COLUMN_NAME)<br \/>\nFROM (<br \/>\nSELECT A.TABLE_NAME, C.COMMENTS, A.COLUMN_NAME||'(&#8216;||TRIM(B.COMMENTS)||&#8217;)&#8217; AS COLUMN_NAME<br \/>\nFROM ALL_IND_COLUMNS A, ALL_COL_COMMENTS B, ALL_TAB_COMMENTS C<br \/>\nWHERE A.TABLE_NAME = B.TABLE_NAME<br \/>\nAND A.COLUMN_NAME = B.COLUMN_NAME<br \/>\nAND A.TABLE_NAME = C.TABLE_NAME<br \/>\nAND A.TABLE_NAME LIKE &#8216;TB_%&#8217;<br \/>\n)<br \/>\nGROUP BY TABLE_NAME<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT TABLE_NAME, MAX(COMMENTS) AS TAB_COMMENTS, WM_CONCAT(COLUMN_NAME) FROM ( SELECT A.TABLE_NAME, C.COMMENTS, A.COLUMN_NAME||'(&#8216;||TRIM(B.COMMENTS)||&#8217;)&#8217; AS COLUMN_NAME FROM ALL_IND_COLUMNS A, ALL_COL_COMMENTS B, ALL_TAB_COMMENTS C WHERE A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND A.TABLE_NAME = C.TABLE_NAME AND A.TABLE_NAME LIKE &#8216;TB_%&#8217; ) GROUP BY TABLE_NAME<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/5"}],"collection":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5"}],"version-history":[{"count":3,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/5\/revisions"}],"predecessor-version":[{"id":8,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=\/wp\/v2\/posts\/5\/revisions\/8"}],"wp:attachment":[{"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hadooh.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}