mirror of
https://github.com/Wisser/Jailer.git
synced 2026-01-02 16:47:20 -06:00
70 lines
3.0 KiB
HTML
70 lines
3.0 KiB
HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
|
|
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
|
<head>
|
|
<meta content="text/html; charset=us-ascii" http-equiv="content-type" />
|
|
|
|
<title>Jailer - Scott.sql</title>
|
|
</head>
|
|
|
|
<body>
|
|
<table style="background-color: rgb(51, 102, 255); text-align: left;" border="0"
|
|
cellpadding="2" cellspacing="0">
|
|
<tbody>
|
|
<tr>
|
|
<td style=
|
|
"height: 24px; background-color: rgb(202, 225, 235); vertical-align: top;">
|
|
<big><span style="font-family: monospace;"><span style=
|
|
"font-weight: bold;"><span style=
|
|
"font-family: monospace;">scott.sql</span></span></span> </big><br /></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
|
|
<table style="width: 100%; text-align: left;" border="0" cellpadding="0" cellspacing=
|
|
"0">
|
|
<tbody>
|
|
<tr>
|
|
<td colspan="2" rowspan="1" style=
|
|
"background-color: rgb(202, 225, 235); vertical-align: top;"><span style=
|
|
"font-family: monospace;">-- generated by Jailer<br />
|
|
--<br />
|
|
-- extraction model: EMPLOYEE where NAME='SCOTT'
|
|
(extractionmodel/scott-without-subordinates.csv)<br />
|
|
-- database URL:
|
|
jdbc:db2://localhost:50001/wisser<br />
|
|
-- database user: scott<br />
|
|
-- exported entities: 9<br />
|
|
--
|
|
DEPARTMENT
|
|
2<br />
|
|
--
|
|
EMPLOYEE
|
|
4<br />
|
|
--
|
|
SALARYGRADE
|
|
3<br />
|
|
<br />
|
|
<br />
|
|
<br />
|
|
Insert into DEPARTMENT(DEPTNO, NAME, LOCATION) values (20, 'RESEARCH', 'DALLAS'),
|
|
(10, 'ACCOUNTING', 'NEW YORK');<br />
|
|
Insert into SALARYGRADE(GRADE, LOSAL, HISAL) values (1, 700, 1200), (4, 2001,
|
|
3000), (5, 3001, 9999);<br />
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
|
|
values (7839, 'KING', 'PRESIDENT', null, '1981-11-17', 5000.00, null, 10);<br />
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
|
|
values (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, null, 20);<br />
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
|
|
values (7788, 'SCOTT', 'ANALYST', 7566, '1982-12-09', 3000.00, null, 20);<br />
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
|
|
values (7876, 'ADAMS', 'CLERK', 7788, '1983-01-12', 1100.00, null, 20);<br />
|
|
scott.sql (END)<br /></span></td>
|
|
</tr>
|
|
</tbody>
|
|
</table><br />
|
|
<br />
|
|
</body>
|
|
</html>
|