외부메모리 -_-

function goRight(){
    var length = document.getElementById("source").options.length;

    if(document.getElementById("source").options.value != ""){
        var cnt = document.getElementById("result").options.length;
        for(var i=0;i<cnt;i++){
            if(document.getElementById("result").options[i].value == document.getElementById("source").value){
                return;
            }
        }
        var option1 = new Option(document.getElementById("source").value, document.getElementById("source").value)
        document.getElementById("result").options[cnt] = option1;
    }
}

function goLeft(){
    var length = document.getElementById("result").options.length;

    for(var i=0;i<length;i++){
        if(document.getElementById("result").options[i].selected){
            document.getElementById("result").options[i] = null;
            break;
        }
    }   
}

function goSave(pageNo){
    var selectedList = "";
    var length = document.frm.result.length;
    var count = 0;
    if (length != 0) {
            for (i=0;i<length;i++) {
                    if (count == 0) {
                        selectedList = document.frm.result.options[i].value;
                    }
                    else {
                        selectedList = selectedFlow + "," + document.frm.result.options[i].value;
                    }
                    count++;
               }
    }

}

selectedList에 list,list,list 형태로 저장.. 나중에 스플릿해서 쓰면 된다.

-- 8i --
SELECT num
     , MIN(DECODE(rn,1,''''||data||''''))
    || MIN(DECODE(rn,2,','''||data||''''))
    || MIN(DECODE(rn,3,','''||data||''''))
  FROM (SELECT num, data
             , ROW_NUMBER() OVER(PARTITION BY num ORDER BY data) rn
          FROM t
        )
 GROUP BY num
;

-- 9i --
SELECT num
     , SUBSTR(MAX(SYS_CONNECT_BY_PATH(''||data||'',',')),2) data
  FROM (SELECT num, data
             , ROW_NUMBER() OVER(PARTITION BY num ORDER BY data) rn
          FROM t
        )
 START WITH rn = 1
 CONNECT BY PRIOR num = num
        AND PRIOR rn = rn - 1
 GROUP BY num
;

-- 10G --
SELECT num
     , REPLACE(SUBSTR(data,2),'@','''') data
  FROM
(
SELECT num,
XMLAGG(XMLELEMENT(x,',@'||data||'@') ORDER BY data).EXTRACT('//text()').GetStringVal() data
  FROM t
 GROUP BY num
)
;

10G XML 함수에서는 따옴표가 &apos; 로 표시되는 관계로
부득이하게 @ 로 대체해서 다시한번 처리했습니다.

데이터가 있으면 update를 하고 데이터가 없으면 insert를 하는 함수
오라클 전용인듯..?

merge into kt_map as kt
using dual