본문 바로가기

전체 보기523

SQL Function # 세로(ROW)로 출력되는 데이터를 가로(COLUMN)형태로 출력하기 WITH before_v as --선행 작업 목록 ( select table_id, job_id, CONDITION, -- rank() over ( partition by CONDITION order by CONDITION) rank /* CONDITION 순번*/ ORDER_ rank from emuser.DEF_LNKI_P ), after_v as --후행 작업 목록 ( select table_id, job_id, CONDITION --rank() over ( partition by CONDITION order by CONDITION) rank /* CONDITION 순번 */ --ORDER_ rank from emuser.DEF.. 2016. 2. 4.
유니코드(UTF-8) 한글 코드표, 한글코드 범위 {AC00-D7AF} U+AC00 to U+AD00 0 1 2 3 4 5 6 7 8 9 A B C D E F UTF8: 234, 176, 128; UNICODE: AC0 가 각 갂 갃 간 갅 갆 갇 갈 갉 갊 갋 갌 갍 갎 갏 UTF8: 234, 176, 144; UNICODE: AC1 감 갑 값 갓 갔 강 갖 갗 갘 같 갚 갛 개 객 갞 갟 UTF8: 234, 176, 160; UNICODE: AC2 갠 갡 갢 갣 갤 갥 갦 갧 갨 갩 갪 갫 갬 갭 갮 갯 UTF8: 234, 176, 176; UNICODE: AC3 갰 갱 갲 갳 갴 갵 갶 갷 갸 갹 갺 갻 갼 갽 갾 갿 UTF8: 234, 177, 128; UNICODE: AC4 걀 걁 걂 걃 걄 걅 걆 걇 걈 걉 걊 걋 걌 걍 걎 걏 UTF8: 234, 177, 144.. 2016. 2. 4.
oracle user 계정 만료 기간 무제한 설정 oracle user 계정 만료 기간 무제한 설정 SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE = 'DEFAULT'; ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ; 2016. 2. 4.
chang archivelog path chang archivelog path show parameters log_archive alter system set log_archive_dest_1='LOCATION=/oracle/product/arch' scope=spfile; 2016. 2. 4.
오라클 ORA-04091 오류 대응 트리거 create or replace PACKAGE AMOUNT_DATA_R_PACK AS TYPE ISEQNO IS TABLE OF AMOUNT_DATA_R.I_SEQNO%TYPE INDEX BY BINARY_INTEGER; TYPE ITDIFNO IS TABLE OF AMOUNT_DATA_R.I_TDIFNO%TYPE INDEX BY BINARY_INTEGER; TYPE CDATDT IS TABLE OF AMOUNT_DATA_R.C_DATDT%TYPE INDEX BY BINARY_INTEGER; TYPE FCRFLW IS TABLE OF AMOUNT_DATA_R.F_CRFLW%TYPE INDEX BY BINARY_INTEGER; TYPE FCRLVL IS TABLE OF AMOUNT_DATA_R.F_CRLV.. 2016. 2. 4.
VSTO 시작하기 좋은 링크 http://csharp.net-informations.com/excel/csharp-open-excel.htm 영어지만 참조 추가랑 기본 문법있다. !! 2016. 2. 4.
반응형

티스토리툴바