본문 바로가기
oracle , mssql 범위 난수 발생 구문 -- oracle select chr(trunc(dbms_random.value(97, 122), 0)) , chr(trunc(dbms_random.value(97, 122), 0)) , chr(trunc(dbms_random.value(33, 90), 0)) , chr(trunc(dbms_random.value(33, 47), 0)) , chr(trunc(dbms_random.value(48, 57), 0)) , chr(trunc(dbms_random.value(33, 90), 0)) from ANY_TABLE -- mssql select lower(char(cast(round((122-97)*rand()+97, 0) as integer))) + '' + lower(char(cast(round((122..
ORACLE - PK, FK 조회 SELECT AA.COLUMN_ID, AA.COLUMN_NAME, BB.COMMENTS, AA.DATA_TYPE, AA.DATA_DEFAULT, CC.PK, AA.NULLABLE, CC.FK FROM ALL_TAB_COLUMNS AA, ALL_COL_COMMENTS BB, (SELECT A.OWNER, A.TABLE_NAME, A.CONSTRAINT_TYPE, COLUMN_NAME, POSITION, CASE WHEN A.CONSTRAINT_TYPE = 'P' THEN 'Y' END AS PK, CASE WHEN A.CONSTRAINT_TYPE = 'R' THEN 'Y' END AS FK FROM ALL_CONSTRAINTS A, ALL_CONS_COLUMNS B WHERE UPPER (A.OWNER) ..
Java JSTL 에서 디버깅하기
java bigdecimal 비교 // java //val1, val2 비교 변수 if(val1.compareTo(BigDecimal.ZERO) == 0){ statusCode = "40";//상태1 } else { Logger.debug("quantity : [{}] | rtnQty : [{}] | compare : [{}]", val2, val1, val2.compareTo(val1)); if(val2.compareTo(val1) == 0){ statusCode = "90";//상태2 } else { statusCode = "50";//상태3 } }
[MSSQL] oracle multi table column update to sql server -- base oracle UPDATE ( select cu.stat as stat , cs.sys_date as last_update_date , cu.user_id as user_id , cu.sys_date as update_date from table_1 cs , table_2 cu where cs.emp_sabun = cu.user_id ) SET STAT = 'N' , update_date = to_char(sysdate, 'yyyymmdd') where user_id IN ( select distinct expired_user from table_a where trunc(expired_date) = trunc(sysdate) and SYSTEM_NAME IN ('xxxxxx','yyyyyy'..
kendo ui jquery grid 에서 datasource 로 grid 갱신 var grid = $("#grid").data("kendoGrid"); var params = { comp_num : '${comp_numn}', masterid : '${masterid}', comp_name : $("#comp_name").val(), emp_div: "${emp_div}", user_name : $("#user_name").val(), user_status : $("#status option:selected").val(), isExport : "Y" }; var dataSource = new kendo.data.DataSource({ transport: { read: { url:"", dataType: "json", type: "POST", data : params } }, pag..
kendo ui jquery dropdownlist option select var custType = "선택값"; var dropdownlist = $("#cust_type").data("kendoDropDownList"); dropdownlist.select(function (dataItem) { return dataItem.value === custType; });
kendo ui jquery grid 에서 동적으로 추가 된 element 를 component 화 시길 때 $("#eqp_list :last-child > td > input").kendoTextBox(); $("#eqp_list :last-child > td > select").kendoDropDownList(); 마지막으로 추가된 자식 요소를 가져와서 kendo 컴포넌트로 만든다.

티스토리툴바