Difference between revisions of "OracleSampleData"
From mi-linux
Jump to navigationJump to search| Line 22: | Line 22: | ||
<th scope="col">DEPTNO</th> | <th scope="col">DEPTNO</th> | ||
</tr> | </tr> | ||
| − | <tr><td>7839</td> | + | <tr><td align="right">7839</td> |
<td>KING</td> | <td>KING</td> | ||
<td>PRESIDENT</td> | <td>PRESIDENT</td> | ||
<td> </td> | <td> </td> | ||
<td>17-NOV-80</td> | <td>17-NOV-80</td> | ||
| − | <td>5000</td> | + | <td align="right">5000</td> |
<td> </td> | <td> </td> | ||
<td align="right">10</td> | <td align="right">10</td> | ||
| Line 42: | Line 42: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7788</td> |
| − | + | <td>SCOTT</td> | |
| − | </td> | + | <td>ANALYST</td> |
| − | <td> | + | <td align="right">7566</td> |
| − | SCOTT | + | <td>16-OCT-15</td> |
| − | </td> | + | <td align="right">3000</td> |
| − | <td> | + | <td align="right"> </td> |
| − | ANALYST | + | <td align="right">20</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td> | ||
| − | 16-OCT-15 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7876</td> |
| − | + | <td>ADAMS</td> | |
| − | </td> | + | <td>CLERK</td> |
| − | <td> | + | <td align="right">7788</td> |
| − | ADAMS | + | <td>19-NOV-15</td> |
| − | </td> | + | <td align="right">1100</td> |
| − | <td> | + | <td align="right"> </td> |
| − | CLERK | + | <td align="right">20</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td> | ||
| − | 19-NOV-15 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7902 |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
</td> | </td> | ||
| + | <td>FORD</td> | ||
| + | <td>ANALYST</td> | ||
| + | <td align="right">7566</td> | ||
| + | <td>03-DEC-91</td> | ||
| + | <td align="right">3000</td> | ||
| + | <td align="right"> </td> | ||
| + | <td align="right">20</td> | ||
</tr> | </tr> | ||
| − | <tr> | + | <tr><td align="right">7369</td> |
| − | <td align="right"> | + | <td>SMITH</td> |
| − | + | <td>CLERK</td> | |
| − | </td> | + | <td align="right">7902</td> |
| − | <td> | + | <td>17-DEC-90</td> |
| − | SMITH | + | <td align="right">800</td> |
| − | </td> | + | <td align="right"> </td> |
| − | <td> | + | <td align="right">20</td> |
| − | CLERK | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td> | ||
| − | 17-DEC-90 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7698</td> |
| − | |||
| − | </td> | ||
<td> | <td> | ||
BLAKE | BLAKE | ||
Revision as of 15:28, 9 January 2016
Sample DataSet
DEPT Table
| DEPTNO | DNAME | LOC |
|---|---|---|
| 10 | ACCOUNTING | NEW YORK |
| 20 | RESEARCH | DALLAS |
| 30 | SALES | CHICAGO |
| 40 | OPERATIONS | BOSTON |
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
|---|---|---|---|---|---|---|---|
| 7839 | KING | PRESIDENT | 17-NOV-80 | 5000 | 10 | ||
| 7566 | JONES | MANAGER | 7839 | 02-APR-91 | 2975 | 20 | |
| 7788 | SCOTT | ANALYST | 7566 | 16-OCT-15 | 3000 | 20 | |
| 7876 | ADAMS | CLERK | 7788 | 19-NOV-15 | 1100 | 20 | |
| 7902 | FORD | ANALYST | 7566 | 03-DEC-91 | 3000 | 20 | |
| 7369 | SMITH | CLERK | 7902 | 17-DEC-90 | 800 | 20 | |
| 7698 |
BLAKE |
MANAGER |
7839 |
01-MAY-81 |
2850 |
|
30 |
7499 |
ALLEN |
SALESMAN |
7698 |
20-FEB-95 |
1600 |
300 |
30 |
7521 |
WARD |
SALESMAN |
7698 |
22-FEB-94 |
1250 |
500 |
30 |
7654 |
MARTIN |
SALESMAN |
7698 |
28-SEP-93 |
1250 |
1400 |
30 |
7844 |
TURNER |
SALESMAN |
7698 |
08-SEP-81 |
1500 |
0 |
30 |
7900 |
JAMES |
CLERK |
7698 |
03-DEC-81 |
950 |
|
30 |
7782 |
CLARK |
MANAGER |
7839 |
09-JUN-89 |
2450 |
|
10 |
7934 |
MILLER |
CLERK |
7782 |
23-JAN-85 |
1300 |
|
10 |
