html, data-

카테고리 없음 2020. 7. 23. 15:54

렌지 상단 메뉴의 [Tools] - [Network Configuration Tool]에서

tnsnames.ora파일을 인식하고 있는 지 확인부탁드립니다.

파일을 인식하고 있지 않다면 오렌지 상단 메뉴의

[Tools] - [Orange Options...] - [Common] - [Environment]에서 Oracle Home을

설정하신 다음 오렌지를 재시작한 뒤, 다시 확인해보시기 바랍니다.

(https://www.warevalley.com/support/orange_view.asp?search_division=ORANGE&page=&num=10844)


pip --trusted-host pypi.org --trusted-host files.pythonhosted.org install install requests

(harryp.tistory.com/831)


Menu(왼쪽상단 비발디 로고 ) > File and select “Import Bookmarks and Settings” 


java yesterday

카테고리 없음 2020. 7. 16. 14:29
                final Calendar cal = Calendar.getInstance();
                cal.add(Calendar.DATE, -1);
                SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd", Locale.KOREA);
                String yesterday = sdf.format(cal.getTime());

    var oCal = frm1.getCalendar("REG_DATE"); //
	//oCal.attachEvent("onChange", function(date, state){
	oCal.attachEvent("onClick",function(date){
  
		// do sth
		
     });

WITH tab1 AS (
SELECT
		RANK() OVER (PARTITION BY tab2.type_code ORDER BY tab2.val1 DESC,  tab2.reg_date DESC) AS RANK
	   ,tab2.type_code 		AS type_code
	   ,tab2.val1 	    AS max_val1		
       ,SUBSTR(tab2.reg_date,1,4) || '-' || SUBSTR(tab2.reg_date,5,2) || '-' || SUBSTR(tab2.reg_date,7,2) AS max_val1_date
 FROM  (
	SELECT '01' type_code,'1260' val1,'20200329' reg_date FROM DUAL UNION ALL
	SELECT '01' type_code,'1252' val1,'20200322' reg_date FROM DUAL UNION ALL
	SELECT '01' type_code,'1249' val1,'20200531' reg_date FROM DUAL UNION ALL
	SELECT '01' type_code,'1242' val1,'20200503' reg_date FROM DUAL UNION ALL
	SELECT '01' type_code,'1239' val1,'20200426' reg_date FROM DUAL UNION ALL
	SELECT '02' type_code,'1385' val1,'20200607' reg_date FROM DUAL UNION ALL
	SELECT '02' type_code,'1376' val1,'20200322' reg_date FROM DUAL UNION ALL
	SELECT '02' type_code,'1376' val1,'20200621' reg_date FROM DUAL UNION ALL
	SELECT '02' type_code,'1372' val1,'20200614' reg_date FROM DUAL UNION ALL
	SELECT '02' type_code,'1371' val1,'20200531' reg_date FROM DUAL)            tab2
)
SELECT tab1.type_code, tab1.max_val1, tab1.max_val1_date
  FROM tab1
 WHERE tab1.RANK = 1
;


C:/Program Files (x86)/Vim/_vimrc

파일을 열어서 

set encoding=utf-8
set fileencodings=utf-8,cp949

추가