선한열심

    DEPTNO ENAME
---------- ----------
        20 SMITH
        30 ALLEN
        30 WARD
        20 JONES
        30 MARTIN
        30 BLAKE
        10 CLARK
        20 SCOTT
        10 KING
        30 TURNER
        20 ADAMS
        30 JAMES
        20 FORD
        10 MILLER
 

    DEPTNO EMPLOYEES
---------- --------------------------------------------------
        10 CLARK,KING,MILLER
        20 SMITH,FORD,ADAMS,SCOTT,JONES
        30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD
       
       
SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees
FROM   emp
GROUP BY deptno;

    DEPTNO EMPLOYEES
---------- --------------------------------------------------
        10 CLARK,KING,MILLER
        20 ADAMS,FORD,JONES,SCOTT,SMITH
        30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD

 출처 - http://blog.naver.com/PostView.nhn?blogId=ggugers&logNo=10151692442

jquery_tr이동.html

<table>
<tr id="header"><td>header</td></tr>
<tr id="tr_1"><td><input type="radio" name="del" value="1">1</td></tr>
<tr id="tr_2"><td><input type="radio" name="del" value="2">2</td></tr>
<tr id="tr_3"><td><input type="radio" name="del" value="3">3</td></tr>
<tr id="tr_4"><td><input type="radio" name="del" value="4">4</td></tr>
<tr id="tr_5"><td><input type="radio" name="del" value="5">5</td></tr>
<tr id="tr_6"><td><input type="radio" name="del" value="6">6</td></tr>
<tr id="tr_7"><td><input type="radio" name="del" value="7">7</td></tr>
</table>
<input type="button" value="up" onclick="moveRowUpDown('up')">
<input type="button" value="down" onclick="moveRowUpDown('down')">

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script>
function moveRowUpDown(option) {
 var num = $('input[name=del]:checked').val();
 if(num==undefined){
  alert("select radio");
  return;
 }
 var element = $("#tr_"+num);
 if(option=="up"){
  if( element.prev().html() != null  && element.prev().attr("id") != "header"){
   element.insertBefore(element.prev());
  }
 }else{
        if( element.next().html() != null ){
            element.insertAfter(element.next());
        }
 }
}
</script>

핵심 : for 문에서 countryList 루프를 돌때

         countryVO.setCarriers 하면 countryList에 추가하여 countryList.get(0).getCarriers() 값이 추가된다

       주소값을 전달해서 그런거 같다

예제)
        List<CountryVO> countryList = DAO.getCountry(ID);        

List<String> countryCodeList = new ArrayList<String>();
if ( countryList != null ) {

       for ( CountryVO countryVO : countryList ) 
       {
            if ( countryVO.getCarrierCount() > 0 ) { 
              countryVO.setCarriers(this.DAO.getCountryCarriersNew(CountryVO.getCountryCode(), CountryVO.getID()));
                }
        }
 }