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) ..
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..
