특정 테이블이 어느 계정에 속해있는지 조회하는 쿼리

SELECT A.OWNER

,C.COMMENTS AS TABLE_COMMENTS

,A.TABLE_NAME

,A.COLUMN_NAME

,B.COMMENTS AS COLUMN_COMMENTS

,A.DATA_TYPE

,A.DATA_LENGTH

,A.NULLABLE

,A.COLUMN_ID

FROM ALL_TAB_COLUMNS A

,ALL_COL_COMMENTS B

,ALL_TAB_COMMENTS C

WHERE 1=1

AND A.OWNER IN

('계정명1','계정명2','계정명3')

AND A.TABLE_NAME = '{테이블명}'

AND A.OWNER = B.OWNER

AND A.TABLE_NAME = B.TABLE_NAME

AND A.COLUMN_NAME = B.COLUMN_NAME

AND A.OWNER = C.OWNER

AND A.TABLE_NAME = C.TABLE_NAME

ORDER BY A.COLUMN_ID;