통계 함수 개발
import org.apache.commons.math3.stat.regression.OLSMultipleLinearRegression;import org.apache.commons.math3.stat.regression.SimpleRegression;import org.apache.commons.math3.distribution.TDistribution;public class RegressionTest { public static void main(String[] args) { // 예제 데이터 (X, Y) double[][] data = { {1, 2}, {2, 3.1}, {3, 5.2}, {4, 7.8}, {5, 11.3}, {6, 15.1} ..
SQL 구분자 기준으로 여러행으로 나누기
WITH temp AS ( SELECT A.COL_0 , A.COL1 , A.COL2 , LEVEL AS lvl , SUBSTR( A.COL1, INSTR(A.COL1, '$', 1, LEVEL) + 1, INSTR(A.COL1 || '$', '$', 1, LEVEL + 1) - INSTR(A...