랩제이

- View 관련된 Dictionary SELECT view_name, text_length, text FROM user_views;

- 부서별최대 급여를 받는 사원 조회 SELECT e.ename, d.dname, m.sal FROM emp e, dept d, (SELECT deptno, MAX(sal) sal FROM emp GROUP BY deptno) m WHERE e.deptno = d.deptno AND e.sal = m.sal

- 사용편의를 위한 View CREATE VIEW v_emp_complex AS SELECT empno, ename, deptno, hiredate FROM emp WHERE (sal*comm) + 12 > 20000 AND deptno = 30 AND job = 'SALESMAN' AND sysdate - 365 + 10 > hiredate; SELECT * FROM v_emp_complex; - 한글 View CREATE VIEW 사원(사번, 성명, 부서번호, 입사일) AS SELECT empno, ename, deptno, hiredate FROM emp WHERE deptno = 30 - 수행속도 향상을 위한 View - 제일 큰 값을 구하여라! - HINT를 사용하였음 : 옵티미아저에게 힌트를 ..

- 함수로 가공된 view는 인서트 업데이트가 안된다. CREATE VIEW v_emp (empno, ename, job, mgr, hiredate, deptno) AS SELECT NVL(empno, null), ename, job, mgr, NVL(hiredate, null), deptno FROM emp WHERE job = 'MANAGER'; - 연산결과만 제공하고 알고리즘을 숨긴다. CREATE VIEW v_emp (empno, ename, annual_sal) AS SELECT empno, ename, (sal + NVL(comm,0))+12 annual_sal FROM emp; - VIew 자체를 read only로 만든다. CREATE VIEW v_emp (empno, ename, annu..

CREATE VIEW v_emp (empno, ename, job, mgr, hiredate, deptno) AS SELECT empno, ename, job, mgr, hiredate, deptno FROM emp WHERE job = 'MANAGER'; CREATE OR REPLACE VIEW v_emp (empno, ename, job, mgr, hiredate, deptno) AS SELECT empno, ename, job, mgr, hiredate, deptno FROM emp WHERE job = 'SALESMAN'; DROP VIEW v_emp;

* List 형식으로 넘기기 - controller HashMap data = new HashMap(); List login = new ArrayList(); data.put("id", "namju"); data.put("password", "1234"); login.add(data); return new ModelAndView( "logins/login", "login", login); - jsp page ${login.id} ${login.password} * domain 객체에 값을 설정하여 넘기기 - domain package kr.actsoft.dlms.login.domain; import java.util.List; import kr.actframeworks.commons.BaseObject;..