1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<!-- 에러 페이지 -->
<error-page>
<error-code>403</error-code>
<location>/error/403</location>
</error-page>
<error-page>
<error-code>404</error-code>
<location>/error/404</location>
</error-page>
<error-page>
<error-code>405</error-code>
<location>/error/405</location>
</error-page>
<error-page>
<error-code>500</error-code>
<location>/error/500</location>
</error-page>
| cs |
1
2
3
|
SELECT department_id, SUM(salary)
FROM employees
GROUP BY department_id
| cs |
1
2
3
4
5
|
SELECT dept.deptname, COUNT(emp.empno) "사원수"
FROM employees emp, department dept
WHERE emp.deptno = dept.deptno
GROUP BY dept.deptname
HAVING COUNT(emp.empno) > 5;
| cs |
1
2
3
4
5
6
7
8
|
SELECT deptno,
CASE deptno
WHEN 10 THEN 'ACCOUNTING'
WHEN 20 THEN 'RESEARCH'
WHEN 30 THEN 'SALES'
ELSE 'OPERATIONS'
END as "Dept Name"
FROM dept;
| cs |
1
2
3
4
|
SELECT deptno, DECODE(deptno, 10 , 'ACCOUNTING' ,
20 , 'RESEARCH' ,
30 , 'SALES', 'OPERATIONS') name
FROM dept;
| cs |
1
|
SELECT * FROM emp WHERE empno = :var ;
| cs |
1
|
SELECT SUBSTR('abcdefg' , 1, 5) res FROM DUAL;
| cs |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
WITH AA AS
(SELECT ROWNUM AS SEQ, 'TEST1' AS NAME, SYSDATE
FROM DUAL
UNION ALL
SELECT ROWNUM AS SEQ, 'TEST2' AS NAME, SYSDATE
FROM DUAL
UNION ALL
SELECT ROWNUM AS SEQ, 'TEST3' AS NAME, SYSDATE FROM DUAL),
BB AS
(SELECT ROWNUM AS SEQ, 'TEST1' AS NAME, SYSDATE
FROM DUAL
UNION ALL
SELECT ROWNUM AS SEQ, 'TEST2' AS NAME, SYSDATE
FROM DUAL
UNION ALL
SELECT ROWNUM AS SEQ, 'TEST3' AS NAME, SYSDATE FROM DUAL)
SELECT * FROM AA, BB WHERE AA.NAME=BB.NAME
| cs |
1
2
|
SELECT empno, NVL2(deptid, 1, 0) dept
FROM emp;
| cs |
1
|
select trunc( 1.23456, 2 ) from dual;
| cs |
