[Oracle] 테이블, 컬럼 조회

-- 테이블명 조회
SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE'

-- 컬럼 조회
SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE
  FROM COLS
 WHERE TABLE_NAME = '테이블명'


-- 컬럼 찾기
SELECT * FROM COLS
WHERE 1=1
  AND TABLE_NAME  LIKE '%' || UPPER([테이블명]) || '%'
  AND COLUMN_NAME LIKE '%' || UPPER([컬럼명]) || '%';

-- 테이블 찾기
SELECT *
  FROM USER_OBJECTS
 WHERE 1 = 1
   AND OBJECT_TYPE = 'TABLE'
   AND OBJECT_NAME LIKE '%' || UPPER([테이블명]) || '%';