일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- QueryDSL
- jmeter
- spring boot
- argo cd
- Spring Open Feign
- coalesce
- spring cloud
- docker compose mysql
- Netty
- vue.js
- redis
- WebLogic
- Selenium
- netflix oss
- Docker Compose
- mybatis
- Redis Sentinel
- RabbitMQ
- MySQL
- weblogic 10
- ChannelPipeline
- docker-compose
- spring boot redis
- cassandra
- KAFKA
- docker
- Hibernate
- JPA
- grafana
- Airflow
- Today
- Total
목록DataBase (25)
IT.FARMER
두가지 방법이 있다고 한다. 1. 첫번째 C:\Documents and Settings\hjk>emctl start dbconsole Environment variable ORACLE_SID not defined. Please define it. C:\Documents and Settings\hjk>set ORACLE_SID=orcl C:\Documents and Settings\hjk>emctl start dbconsole OC4J Configuration issue. C:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole_eshsdevext.hynix.com_orcl not found. C:\Documents and Settings\hjk>emctl star..
SELECT 'UPDATE HCTB_CHK_STMT SET HOSPITAL_CD = '''||HOSPITAL_CD ||''' WHERE ENP_NO = '''|| FAMILY_NO || ''' AND CHK_YEAR=''2010'' ' FROM HCTB_EXECUTIVE_CHECKUP_DETAIL WHERE FAMILY_SEQ ='0' AND HOSPITAL_CD IS NOT NULL
0. 단순히 0~12월 까지 표현 해줌. SELECT LPAD(LEVEL, 2, '0') LV FROM DUAL CONNECT BY LEVEL
DICT, LAST_DAY FUNCTION 사용 dict : dictionary 테이블 1. 등록된 데이터만 나오게 할 경우 SELECT TO_CHAR(TO_DATE(JRNL_DT,'yyyy-mm-dd'),'dd') AS JRNL_DT, SUM(TAKEOUT_AMOUNT) AS TAKEOUT_AMOUNT FROM HCTB_MEDICAL_INJ_PRE GROUP BY TO_CHAR(TO_DATE(JRNL_DT,'yyyy-mm-dd'),'dd') EX) JRNL_DT TAKEOUT_AMOUNT 10 48 11 2 12 1 2. 1~31일 까지 모두 나오게 할때, 데이터가 없는경우 0 ( DICT 테이블을 사용하여 임시로 데이터를 생성한다.) 2.1 UNION ALL 방식 SELECT JRNL_DT, SUM(..
2. Sample MERGE INTO CRCD_WF_CARD A USING DUAL ON ( A.WF_NO = ? AND A.CRD_NO =? ) WHEN MATCHED THEN UPDATE SET A.CRD_TYPE =? , A.FML_SSN =? , A.FMLHG_NM =? , A.FMLENG_NM =? , A.OCRD_NO =? , A.DSN_CD =? , A.DSN_NM =? , A.BRD_CD =? , A.CRD_GRD =? , A.INTGLMT_AMT =? , A.FML_STLACCT_NO =? , A.CRD_ISSUE_DT =? WHEN NOT MATCHED THEN INSERT ( A.WF_NO , A.CRD_NO , A.CRD_TYPE , A.FML_SSN , A.FMLHG_NM , A...
1. 설명(1/1) MERGE INTO 테이블명 alias USING [테이블명 | 뷰명 | subquery] alias ON 조건 WHEN MATCHED THEN UPDATE SET ... WHEN NOT MATCHED THEN INSERT ... VALUES ...; 1.설명(1/2) MERGE INTO table_name alias --테이블 명만 올수 있음(셀렉트 쿼리 No) USING (table|view|subquery) alias --일반적으로 쓰는 쿼리 Ok ON (join condition) --where 절이라고 생각하면됨(조건에 서브 OK) WHEN MATCHED THEN --데이터 중복건이 있는경우 Update UPDATE SET col1 = val1[, col2 = val2…] W..
connect by prior / sys_connect_by_path with t as ( select 1 key1, '가' key2, '나' key3, 10 key4 from dual union all select 2 key1, '가' key2, '나' key3, 20 key4 from dual union all select 3 key1, '다' key2, '라' key3, 30 key4 from dual union all select 4 key1, '다' key2, '라' key3, 40 key4 from dual union all select 5 key1, '다' key2, '라' key3, 50 key4 from dual union all select 6 key1, '마' key2, '바' key..