Skip to content

Commit 3541328

Browse files
sqlparsersqlparser
committed
oracle insert sample
1 parent c7dfc59 commit 3541328

1 file changed

Lines changed: 14 additions & 0 deletions

File tree

‎samples/oracle_insert.sql‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
INSERT INTO deptsal
2+
(dept_no,
3+
dept_name,
4+
salary)
5+
SELECT d.deptno,
6+
d.dname,
7+
SUM(e.sal + Nvl(e.comm, 0)) AS sal
8+
FROM dept d
9+
left join (SELECT *
10+
FROM emp
11+
WHERE hiredate > DATE '1980-01-01') e
12+
ON e.deptno = d.deptno
13+
GROUP BY d.deptno,
14+
d.dname;

0 commit comments

Comments
 (0)