이응기역

<script>
var dictionary = {
  "cats": [1, 2, 37, 38, 40, 32, 33, 35, 39, 36],
  "dogs": [4, 5, 6, 3, 2]
};

// Get the keys
var keys = Object.keys(dictionary);

console.log(keys);

for (var key in dictionary) {
	console.log("key:", key);
  if (dictionary.hasOwnProperty(key)) {
    keys.push(key);
  }
}

</script>

	var arr_GridRecords = [
		 {"header":input_check,	"ColumnId":"CHK",			"ColumnType":"ch",  "InitWidth":50}
		,{"header":"NO",		"ColumnId":"NO",			"ColumnType":"ro",  "InitWidth":50}
		,{"header":"대표상품코드",	"ColumnId":"REPR_COMMODITY_CD",	"ColumnType":"ro",  "InitWidth":80}
		,{"header":"재고상품코드",	"ColumnId":"STOC_COMMODITY_CD",	"ColumnType":"ro",  "InitWidth":150}            
		,{"header":"재고상품명",	"ColumnId":"STOC_COMMODITY_NM",	"ColumnType":"ro",  "InitWidth":230}            
		,{"header":"비고",		"ColumnId":"RMK",			"ColumnType":"ed",  "InitWidth":130}
		,{"header":"",			"ColumnId":"SER_NO",		"ColumnType":"ro",  "InitWidth":0}
		,{"header":"",			"ColumnId":"NEW_SAVE_YN",	"ColumnType":"ro",  "InitWidth":0}
		,{"header":"",			"ColumnId":"SER_NO2",		"ColumnType":"ro",  "InitWidth":0}
		,{"header":"",			"ColumnId":"DEL_YN",		"ColumnType":"ro",  "InitWidth":0}
		,{"header":"할당량",		"ColumnId":"ASSG_QTY",		"ColumnType":"edn", "InitWidth":50}
		,{"header":"등록일",		"ColumnId":"STD_DE",		"ColumnType":"ro",  "InitWidth":90}
		,{"header":"회사코드",		"ColumnId":"COMP_CD",		"ColumnType":"ro",  "InitWidth":30}
	];


	var arr_Header = [];
	var arr_ColumnIds = [];
	var arr_ColTypes = [];
	var arr_InitWidths = [];

	arr_GridRecords.forEach(function(record){
		for (const [key, value] of Object.entries(record)) {
			if (key == "header") {
					arr_Header.push(value);
			}
			else if (key == "ColumnId") {
					arr_ColumnIds.push(value);
			}
			else if (key == "ColumnType") {
					arr_ColTypes.push(value);
			}
			else if (key == "InitWidth") {
					arr_InitWidths.push(value);
			}
		
		}	
	});	
	console.log('@@@@@@@@@@', arr_Header);
	
	grdDetailPOP.setHeader(arr_Header);
	grdDetailPOP.setColumnIds(arr_ColumnIds.toString());
	grdDetailPOP.setColTypes(arr_ColTypes.toString());
	grdDetailPOP.setInitWidths(arr_InitWidths.toString());				 

<script>
const test = {a: 1, b: 2, c: 3};

for (const [key, value] of Object.entries(test)) {
  console.log(key, value);
}
</script>

www.stackoverflow.com/questions/7241878/for-in-loops-in-javascript-key-value-pairs

team > cleanup

https://blog.outsider.ne.kr/253

SELECT OWNER , OBJECT_NAME , SUBOBJECT_NAME , OBJECT_TYPE , CREATED , LAST_DDL_TIME , TIMESTAMP , STATUS , TEMPORARY 
FROM ALL_OBJECTS 
WHERE OBJECT_TYPE = 'TABLE'
ORDER BY CREATED DESC ;

https://hello-nanam.tistory.com/50

https://animal-park.tistory.com/83

 메뉴에서 Run - Run Configurations 클릭

Common으로 들어가서 Default에서 Other로 변경해준 뒤 UTF-8 로 변경합니다.

서버 (eg. Tomcat) 다시 기동 

파일>새로 만들기>PL/SQL 편집기

Try right clicking on a project that was connected, go to Team -> Share Project, select SVN (as opposed to CVS), and see if the wizard that
comes up will allow you to reconnect your project(s).

https://www.eclipse.org/forums/index.php/t/14897/

    declare
      type NumberVarray is varray(100) of NUMERIC(10);
      myArray NumberVarray;
    BEGIN
      myArray := NumberVarray(1,10,100,1000,10000);

      --myArray(1) := 2;

      for i in myArray.first..myArray.last
      loop
        dbms_output.put_line('myArray(' || i || '): ' || myArray(i));
      end loop;  
    end;

(https://stackoverflow.com/questions/3545379/oracle-pl-sql-arrays)

WITH ASSERT (G, N, N2) AS (
    SELECT  'SL',  2264,  2040 FROM DUAL
UNION ALL SELECT  'SH', 22634, 20380 FROM DUAL
)
SELECT
G AS  PRICE_GRADE      -- 등급
        ,N AS  COST -- 원가1       D4
        ,N2 AS COST2 -- 원가2       D4
FROM ASSERT;