It's Repository

blog.selpa.co.kr

포토로그



[오라클] 컬럼명으로 도메인 검증하기 oracle/mysql

select 
T.COLUMN_NAME
, count (T.COLUMN_NAME)
from 
(
SELECT 
distinct COLUMN_NAME, DATA_TYPE, DATA_LENGTH
FROM ALL_TAB_COLUMNS 
WHERE OWNER = 'SELPA'
order by COLUMN_NAME asc
) T group by T.COLUMN_NAME HAVING COUNT(T.COLUMN_NAME) > 1

덧글

댓글 입력 영역