Oracle

Oracle 쿼리

-- 인덱스 조회  
SELECT TABLE_NAME, INDEX_NAME, VISIBILITY FROM USER_INDEXES  
ORDER BY TABLE_NAME ASC;  
SELECT * FROM USER_INDEXES;  
  
-- Primary Key, Foreign Key 등 확인  
SELECT UC.CONSTRAINT_NAME, UC.TABLE_NAME, UCC.COLUMN_NAME, UC.CONSTRAINT_TYPE, UC.R_CONSTRAINT_NAME  
FROM USER_CONSTRAINTS UC, USER_CONS_COLUMNS UCC  
WHERE UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME  
AND UC.CONSTRAINT_TYPE = 'R';
/*
P : Primary Key
R : Foreign Key
U : Unique
C : Not Null, Check
*/

-- 컬럼으로 조회
SELECT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS
WHERE OWNER LIKE '${소유자명}'
AND COLUMN_NAME LIKE '${컬럼명}';

-- 캐릭터셋 조회
select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';