DB17 MSSQL / column comment / add , update, delete - 조회 SELECT obj.name AS TableName, col.name AS ColumnName, ep.value AS ColumnComment FROM sys.extended_properties AS ep INNER JOIN sys.objects AS obj ON ep.major_id = obj.object_id INNER JOIN sys.columns AS col ON ep.major_id = col.object_id AND ep.minor_id = col.column_id WHERE obj.type_desc = 'USER_TABLE' AND ep.class_desc = 'OBJECT_OR_COLUMN' AND ep.name = 'MS_Description'; - 주석 추가 EXEC sp_ad.. 2024. 2. 26. oracle / DEFAULT_TABLESPACE -- DEFAULT_TABLESPACE 조회 SELECT USERNAME, DEFAULT_TABLESPACE FROM USER_USERS WHERE USERNAME = '[유저명]'; 2022. 4. 14. oracle / sqlplus / UTF8 / 한글깨짐 1. 환경설정확인 # env | grep LANG NLS_LANG=KOREAN_KOREA.AL32UTF8 LANG=en_US.UTF-8 # 2.환경설정값 추가 # export NLS_LANG=KOREAN_KOREA.AL32UTF8 3. 설정값 확인 4. UTF8 로 sql저장 5. 파일 서버로 업로드 6. sqlplus로 실행 @파일명 2022. 1. 3. oracle xe [root@gs product]# echo $ORACLE_HOME /opt/oracle/product/18c/dbhomeXE [root@gs product]# echo $ORACLE_SID XE [root@gs product]# echo $ORACLE_BASE /opt/oracle [root@gs product]# export ORACLE_SID=XE export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE export ORACLE_BASE=/opt/oracle cd /opt/oracle/product/18c/dbhomeXE/bin /opt/oracle/product/18c/dbhomeXE/bin/exp 유저명/비밀번호 file=덤프파일명 owner=유저명 statis.. 2021. 2. 10. 이전 1 2 3 4 5 다음 반응형