{"id":1188,"date":"2016-01-03T10:12:08","date_gmt":"2016-01-03T10:12:08","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1188"},"modified":"2016-01-03T10:12:08","modified_gmt":"2016-01-03T10:12:08","slug":"%ec%9d%b8%eb%8d%b1%ec%8a%a4-%ec%a1%b0%ed%9a%8c%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1188","title":{"rendered":"\uc778\ub371\uc2a4 \uc870\ud68c\ud558\uae30"},"content":{"rendered":"

# \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \uc778\ub371\uc2a4 \uc870\ud68c\ud558\uae30 <\/SPAN><\/P>
\n

col INDEX_OWNER for a10 <\/SPAN><\/P>
\n

col INDEX_NAME for a15 <\/SPAN><\/P>
\n

col TABLE_OWNER for a10 <\/SPAN><\/P>
\n

col TABLE_NAME for a15 <\/SPAN><\/P>
\n

col COLUMN_NAM for a15 <\/SPAN><\/P>
\n

   <\/P>
\n

SELECT A.uniqueness, <\/SPAN><\/P>
\n

b.* <\/SPAN><\/P>
\n

FROM ALL_INDEXES a, <\/SPAN><\/P>
\n

ALL_IND_COLUMNS b <\/SPAN><\/P>
\n

WHERE a.index_name = b.index_name <\/SPAN><\/P>
\n

AND a.table_name=upper(‘[TABLE_NAME]’); <\/SPAN><\/P>
\n

   <\/P>
\n

ex) <\/SPAN><\/P>
\n

SELECT A.uniqueness, <\/SPAN><\/P>
\n

b.* <\/SPAN><\/P>
\n

FROM ALL_INDEXES a, <\/SPAN><\/P>
\n

ALL_IND_COLUMNS b <\/SPAN><\/P>
\n

WHERE a.index_name = b.index_name <\/SPAN><\/P>
\n

AND a.table_name=upper(‘BONUS’); <\/SPAN><\/P>
\n

   <\/P>
\n

\uc2e4\ud589 \uacb0\uacfc <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

   <\/P>
\n

# \ud2b9\uc815 \uc720\uc800\uc758 \uc778\ub371\uc2a4 \uc870\ud68c\ud558\uae30 <\/SPAN><\/P>
\n

select object_name, object_type <\/SPAN><\/P>
\n

from dba_objects <\/SPAN><\/P>
\n

where owner=’SCOTT’ and object_type = ‘INDEX’ ; <\/SPAN><\/P>
\n

<\/SPAN><\/P>
\n

  <\/SPAN> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

# \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \uc778\ub371\uc2a4 \uc870\ud68c\ud558\uae30 col INDEX_OWNER for a10 col INDEX_NAME for a15 col TABLE_OWNER for a10 col TABLE_NAME for a15 col COLUMN_NAM for a15     SELECT A.uniqueness, b.* FROM ALL_INDEXES a, ALL_IND_COLUMNS b WHERE a.index_name = b.index_name AND a.table_name=upper(‘[TABLE_NAME]’);     ex) SELECT A.uniqueness, b.* FROM ALL_INDEXES a, ALL_IND_COLUMNS b WHERE a.index_name = […]<\/p>\n","protected":false},"author":1,"featured_media":1189,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[676,677],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile5.uf.255F9B415688F3F6252313.png?fit=871%2C187","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1188"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1188"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1188\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1189"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1188"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}