달력

52011  이전 다음

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  •  
  •  
  •  
  •  

'2011/05'에 해당되는 글 1건

  1. 2011.05.13 Oracle Object List가져오기

SELECT O.OBJECT_NAME
, O.OBJECT_TYPE
, O.STATUS
, O.LAST_DDL_TIME
, O.OBJECT_ID
, NVL(D.DEBUGINFO, 'F') DEBUGINFO
FROM SYS.DBA_OBJECTS O
, SYS.ALL_PROBE_OBJECTS D
WHERE O.OWNER = 'USER'
AND O.OBJECT_TYPE = 'SYNONYM'
AND O.OBJECT_ID = D.OBJECT_ID (+)
AND O.OBJECT_NAME = D.OBJECT_NAME (+)
AND O.OBJECT_TYPE = D.OBJECT_TYPE (+)
AND D.OWNER (+) = 'USER'

ORDER BY O.OBJECT_TYPE
, O.OBJECT_NAME

'Com?Come~ > Oracle' 카테고리의 다른 글

Oracle Object List가져오기  (0) 2011.05.13
IMP-00058: Oracle 오류 12560이 발생했습니다.  (0) 2010.11.17
Posted by Trauma