전체 글 (175) 썸네일형 리스트형 Mircro Service Architecture 구현 1. 어플리케이션 클래스에 등록@EnableFeignClients@SpringBootApplication@ComponentScan(basePackages = "com.osm.erp"public class OsmApplication { public static void main(String[] args) { SpringApplication.run(OsmApplication.class, args); }} 2. config.yml 에 등록 feignclient: url: apigw: http://dev-apigw-init.sm.com:7880 apikey: pay: xxx-xxx-xxx payreceive: yyy-yyy-yyy 3. FeignConfig.java im.. WITH 별칭1 AS(), 별칭2 AS() SELECT * FROM -> 편집해서 오른쪽 정렬로 볼것 ! /*master.getModelList*/WITH SUBSPRODGRP AS ( SELECT SUBS_PRODGRP_CD, SUBS_PRODGRP_NM, CORP_CD, PR_CMPT_APPL_YN FROM XSBMT_SUBS_PRODGRP_MST WHERE CORP_CD = #{corpCd} ), CLBKCGRP AS ( SELECT CMN_CD AS CD, .. Recursive 사용 예시 WITH RECURSIVE hierarchys AS ( SELECT IPG1.* FROM IF_PRODUCT_GRP AS IPG1 WHERE PRD_GRP_CD IN ('HCWCHB') UNION SELECT IPG2.* FROM IF_PRODUCT_GRP AS IPG2 INNER JOIN herarcys h ON IPG2.PRD_GRP_CD = h.UPPER_PRD_CD)SELECT * FROM hierarchys GROUP BY PRD_GRP_CD ORDER BY PRD_GRP_LEVEL ASC; 이전 1 2 3 4 ··· 59 다음