[ORACLE] 특정 이름을 컬럼으로 가지는 테이블 찾기

특정 이름을 컬럼으로 가지는 테이블 찾기

 SELECT TNAME, TABLE_NAME, B.CONSTRAINT_NAME
          FROM COL A
               LEFT OUTER JOIN (
                                  SELECT TABLE_NAME, CONSTRAINT_NAME
                                    FROM USER_CONSTRAINTS
                                   WHERE CONSTRAINT_TYPE = 'R'
                                ) B ON A.TNAME = B.TABLE_NAME
         WHERE CNAME = '컬럼명'
           AND TNAME IN (SELECT TNAME FROM TAB WHERE TNAME NOT LIKE 'BIN%' AND TABTYPE = 'TABLE')
        ORDER BY B.CONSTRAINT_NAME ASC
        ;