반응형
SELECT A.uniqueness,
b.*
FROM ALL_INDEXES a,
ALL_IND_COLUMNS b
WHERE a.index_name = b.index_name
AND a.table_name=upper('UNFI_AGMT_INFO'); // 테이블명
출처: http://blog.naver.com/kai1202?Redirect=Log&logNo=20069920591
b.*
FROM ALL_INDEXES a,
ALL_IND_COLUMNS b
WHERE a.index_name = b.index_name
AND a.table_name=upper('UNFI_AGMT_INFO'); // 테이블명
출처: http://blog.naver.com/kai1202?Redirect=Log&logNo=20069920591
반응형
