ArrayList<HashMap<String, String>> mylist = new ArrayList<HashMap<String, String>>();
mylist = (ArrayList)(dhtmlxService.selectListForGrid("sqlid1234", hm)).get("data");
mylist.get(0).put("CAR_NM","new car name");
log.debug(Arrays.asList(mylist)); // method 1
mapReturn.put("clientlist" , mylist); Window > Show View > Other... and select SVN ... SVN Resource History View.
Link with Editor
Window > Prefernces > General > Appearance > Colors and Fonts
Debug > Console font
DECLARE
TYPE array_of_numbers IS varray(100) OF varchar2(20);
cities_ids array_of_numbers;
BEGIN
DBMS_OUTPUT.PUT_LINE('Begin...');
WITH tab1 AS (
SELECT 'Stockholm' AS id FROM DUAL
UNION ALL SELECT 'Tokyo' AS id FROM DUAL
UNION ALL SELECT 'Helsinki' AS id FROM DUAL
)
select id BULK COLLECT into cities_ids from tab1;
FOR i IN 1..cities_ids.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(cities_ids(i));
END LOOP;
END;
https://blogs.oracle.com/oraclemagazine/bulk-processing-with-bulk-collect-and-forall
https://stackoverflow.com/questions/24488620/how-to-select-into-array-of-numbers-in-oracle-pl-sql
sqlgate tip
--DBMS_OUTPUT 창
보기 > DBMS OUTPUT (alt+v d)
--PL/SQL 편집
파일>새로 만들기>PL/SQL 편집기
# 디렉토리 없이 복사
find SRC_DIR -type f -exec cp {} TGT_DIR \;
SELECT TO_CHAR(1234.56, '0,000.00') FROM dual; -- 1,234.56
SELECT TO_NUMBER(REPLACE('1,234.56', ',', '')) FROM dual;--1234.56
