// 포매터
function myFormatter(cellvalue, options, rowObject) {
	var retString = "";
	var strJsonText = JSON.stringify(rowObject);
    strJsonText = strJsonText.replace(/\"/gi, "'");
    	
    // 문항관리
	if ( cellvalue.toUpperCase() == "QUESTION_MGMNT" ) {
		retString = "문항관리";
	}
    // 미리보기
	else if ( cellvalue.toUpperCase() == "PREVIEW" ) {
		retString = "미리보기";
	}
    // 진단명
	else if ( /(.+)/gi.test(cellvalue) == true ) {
		retString = "" + cellvalue + "";
	}
	else {
		retString = cellvalue;
	}
    
	return retString;
}

public class AClass {
}

public class BClass extends AClass {
}

AClass aIns = new AClass();
BClass bIns = new BClass();

// 참
if ( aIns instanceof AClass ) {}

// 참
if ( bIns instanceof AClass ) {}

// 거짓
if ( aIns instanceof BClass ) {}

// 참
if ( bIns instanceof BClass ) {}

--TRUNC(값[, 포메터])
-- 11.2
SELECT TRUNC(11.22, 1) FROM DUAL;

-- 11
SELECT TRUNC(11.22) FROM DUAL;


-- 포메터를 음수(-)로 지정하면 소수점 이상 자리 절삭 가능
-- 10
SELECT TRUNC(11.22, -1) FROM DUAL; 

-- 110
SELECT TRUNC(111.22, -1) FROM DUAL; 

-- 100
SELECT TRUNC(111.22, -2) FROM DUAL; 

-- 0
SELECT TRUNC(111.22, -3) FROM DUAL; 

-- HOUR
SELECT
  ROUND(((TO_DATE('20111122110000', 'YYYYMMDDHH24MISS')-TO_DATE('20111122100000', 'YYYYMMDDHH24MISS'))*24),3) AS DIFF_HOUR
  FROM DUAL
  ;

-- MINUTE
SELECT
  ROUND(((TO_DATE('20111122110000', 'YYYYMMDDHH24MISS')-TO_DATE('20111122100000', 'YYYYMMDDHH24MISS'))*24*60),3) AS DIFF_MINUTE
  FROM DUAL
  ;

-- SECOND
SELECT
  ROUND(((TO_DATE('20111122110000', 'YYYYMMDDHH24MISS')-TO_DATE('20111122100000', 'YYYYMMDDHH24MISS'))*24*60*60),3) AS DIFF_SECOND
  FROM DUAL
  ;

//import java.text.*;
//import java.util.*;

// YYYYMMDDHH24MI
Date d = Calendar.getInstance().getTime();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
String startDate = sdf.format(d);

	SELECT INF.EXAMNUM
	  FROM (SELECT EX.EXAMNUM                           /* 문제번호 */
	              ,EX.SUBJ                              /* 과정코드 */
	              ,EX.LESSON                            /* 차시 */
	              ,EX.EXAMTYPE                          /* 문제분류 */
	              ,EX.LEVELS                            /* 난이도 */
	          FROM EXAM EX
	         WHERE 1 = 1
	           AND SUBJ              = #subj#
	           AND TO_NUMBER(LESSON) = #lesson#
	           AND EXAMTYPE          = #examtype#
	           AND LEVELS            = #levels#
	         ORDER BY DBMS_RANDOM.VALUE
	      ) INF
	 WHERE ROWNUM <= TO_NUMBER(TO_CHAR(#examcnt#))

-- INTERVAL '30' : 30분 전까지의 데이터를 확인
-- 오라클 설정에 따라 읽을수 있는 시간이 달라질수 있습니다.
INSERT INTO [테이블명]
SELECT * 
  FROM [테이블명] AS OF TIMESTAMP ( SYSTIMESTAMP - INTERVAL '30' MINUTE)

-- ABCD를 출력
SELECT UPPER('abcd') FROM DUAL

-- abcd를 출력
SELECT LOWER('ABCD') FROM DUAL

Oracle/PLSQL: Mod Function

In Oracle/PLSQL, the mod function returns the remainder of m divided by n.

The syntax for the mod function is:

mod( m, n )

The mod is calculated as:

m - n * floor(m/n)

Note:

The mod function uses the floor function in its formula, whereas the remainder function uses the round function in its formula.

The mod function returns m if n is 0.

Applies To:

• Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

In Oracle/PLSQL, the to_number function converts a string to a number.

The syntax for the to_number function is:

to_number( string1, [ format_mask ], [ nls_language ] )

string1 is the string that will be converted to a number.

format_mask is optional. This is the format that will be used to convert string1 to a number.

nls_language is optional. This is the nls language used to convert string1 to a number.

Applies To:

• Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

to_number('1210.73', '9999.99')	would return the number 1210.73
to_number('546', '999')	would return the number 546
to_number('23', '99')	would return the number 23

Since the format_mask and nls_language parameters are optional, you can simply convert a text string to a numeric value as follows:

  
  

    
        -1
        

배열, 리스트, 컬렉션, Map등의 순환처리를 할수 있다.

// java 코드

map.put("key1", "value1");

map.put("key2", "value2");

// JSTL 코드

<c:foreach var="item" items="${map}">

    ${item.key} : ${item.value}

</c:foreach>

// json text -> object
var objText = '{"name":"뚱2"}';
var obj = JSON.parse(objText);

// json Object -> text
var newText = JSON.stringify(obj);

// Object
JSON.parse('{"name":"뚱2"}');
// Not Object
JSON.parse("{'name':'뚱2'}");

-- 결과 : 3입니다.
SELECT DECODE(3, 1,'1입니다', 2, '2입니다.', 3, '3입니다.', '1-3의 숫자가 아닙니다.')
  FROM DUAL  

-- 101을 출력
SELECT CEIL(100.5) FROM DUAL

-- 100을 출력
SELECT FLOOR(100.5) FROM DUAL

// 추가
$("< OPTION >< /OPTION >")
	.attr("selected", "selected")
	.text("추가")
	.attr("value", "추가")
	.appendTo("select[name='test']");

// 선택
var value = $("select[name='test'] option:selected").val();
var name = $("select[name='test'] option:selected").text();

// 특정 삭제
$("select[name='test'] option[value='추가']").remove();
// 선택 삭제
$("select[name='test'] option:selected").remove();
// 모두 삭제
$("select[name='test'] option").remove();

    // 승인
	$("#btn_approval").click(function() {
		var selRows = $(DF.ID.GRID_MAIN).getGridParam("selarrrow");
		if ( selRows.length == 0) {
			alert("항목을 선택해 주세요.");
			return;
		}
			
		$.ajax({
		     type: 'POST'
		    ,url : DF.URL.APPROVAL
		    ,data: {id : selRows}
			,success: function(data) {
				var ret = eval("(" + data + ")");
				if (ret.success == "true") {
					alert(ret.message);
					$(DF.ID.GRID_MAIN).trigger("reloadGrid");
				}

		    }
			,error: function(result) {
		    }
		});		
	});