오라클 스키마 조회 퀴리

-- TABLE
SELECT A.NAME, B.COMMENT$
  FROM OBJ$ A, COM$ B
 WHERE A.NAME LIKE 'BEMO%' AND TYPE# = 2
   AND B.COL#(+) IS NULL
   AND A.OBJ# = B.OBJ#(+);

-- VIEW
SELECT A.NAME, B.COMMENT$
  FROM OBJ$ A, COM$ B
 WHERE A.NAME LIKE 'BEMO%' AND TYPE# = 4
   AND B.COL#(+) IS NULL
   AND A.OBJ# = B.OBJ#(+);

-- COLUMN
SELECT O.NAME, C.NAME, CO.COMMENT$
  FROM SYS.OBJ$ O, SYS.COL$ C, SYS.COM$ CO
 WHERE O.NAME LIKE 'BEMO%'
   AND O.TYPE# IN (2, 4)
   AND O.OBJ# = C.OBJ#
   AND C.OBJ# = CO.OBJ#(+)
   AND C.INTCOL# = CO.COL#(+)
   AND BITAND(C.PROPERTY, 32) = 0;