Difference between revisions of "OracleSampleData"
From mi-linux
Jump to navigationJump to search| Line 23: | Line 23: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7876</td> |
| − | 7876 | + | <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"> | ||
| − | 7788 | ||
| − | </td> | ||
| − | <td> | ||
| − | 19-NOV-15 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1100 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 20 | ||
| − | </td> | ||
</tr> | </tr> | ||
| − | <tr> | + | <tr><td align="right">7499</td> |
| − | <td align="right"> | + | <td>ALLEN</td> |
| − | 7499 | + | <td>SALESMAN</td> |
| − | </td> | + | <td align="right">7698</td> |
| − | <td> | + | <td>20-FEB-95</td> |
| − | ALLEN | + | <td align="right">1600</td> |
| − | </td> | + | <td align="right">300</td> |
| − | <td> | + | <td align="right">30</td> |
| − | SALESMAN | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7698 | ||
| − | </td> | ||
| − | <td> | ||
| − | 20-FEB-95 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1600 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 30 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7698</td> |
| − | 7698 | + | <td>BLAKE</td> |
| − | </td> | + | <td>MANAGER</td> |
| − | <td> | + | <td align="right">7839</td> |
| − | BLAKE | + | <td>01-MAY-81</td> |
| − | </td> | + | <td align="right">2850</td> |
| − | <td> | + | <td align="right"> </td> |
| − | MANAGER | + | <td align="right">30</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7839 | ||
| − | </td> | ||
| − | <td> | ||
| − | 01-MAY-81 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 2850 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 30 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7782</td> |
| − | 7782 | + | <td>CLARK</td> |
| − | </td> | + | <td>MANAGER</td> |
| − | <td> | + | <td align="right">7839</td> |
| − | CLARK | + | <td>09-JUN-89</td> |
| − | </td> | + | <td align="right">2450</td> |
| − | <td> | + | <td align="right"> </td> |
| − | MANAGER | + | <td align="right">10</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7839 | ||
| − | </td> | ||
| − | <td> | ||
| − | 09-JUN-89 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 2450 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 10 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7902</td> |
| − | 7902 | + | <td>FORD</td> |
| − | </td> | + | <td>ANALYST</td> |
| − | <td> | + | <td align="right">7566 |
| − | FORD | + | </td><td> |
| − | </td> | + | 03-DEC-91</td> |
| − | <td> | + | <td align="right">3000</td> |
| − | ANALYST | + | <td align="right"> </td> |
| − | </td> | + | <td align="right">20</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"> | + | <td align="right">7900</td> |
| − | 7900 | + | <td>JAMES</td> |
| − | </td> | + | <td>CLERK</td> |
| − | <td> | + | <td align="right">7698</td> |
| − | JAMES | + | <td>03-DEC-81</td> |
| − | </td> | + | <td align="right">950</td> |
| − | <td> | + | <td align="right">  |
| − | CLERK | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7698 | ||
| − | </td> | ||
| − | <td> | ||
| − | 03-DEC-81 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | |||
| − | </td> | ||
| − | <td align="right"> | ||
| − |   | ||
| − | |||
| − | |||
| − | |||
</td> | </td> | ||
| + | <td align="right">30</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7566</td> |
| − | 7566 | + | <td>JONES</td> |
| − | </td> | + | <td>MANAGER</td> |
| − | <td> | + | <td align="right">7839</td> |
| − | JONES | + | <td>02-APR-91</td> |
| − | </td> | + | <td align="right">2975</td> |
| − | <td> | + | <td align="right"> </td> |
| − | MANAGER | + | <td align="right">20</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7839 | ||
| − | </td> | ||
| − | <td> | ||
| − | 02-APR-91 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 2975 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 20 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7839</td> |
| − | 7839 | + | <td>KING</td> |
| − | </td> | + | <td>PRESIDENT</td> |
| − | <td> | + | <td align="right"> </td> |
| − | KING | + | <td>17-NOV-80</td> |
| − | </td> | + | <td align="right">5000</td> |
| − | <td> | + | <td align="right"> </td> |
| − | PRESIDENT | + | <td align="right">10</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td> | ||
| − | 17-NOV-80 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 5000 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 10 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7654</td> |
| − | 7654 | + | <td>MARTIN</td> |
| − | </td> | + | <td>SALESMAN</td> |
| − | <td> | + | <td align="right">7698</td> |
| − | MARTIN | + | <td>28-SEP-93</td> |
| − | </td> | + | <td align="right">1250</td> |
| − | <td> | + | <td align="right">1400</td> |
| − | SALESMAN | + | <td align="right">30</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7698 | ||
| − | </td> | ||
| − | <td> | ||
| − | 28-SEP-93 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1250 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1400 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 30 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7934</td> |
| − | 7934 | + | <td>MILLER</td> |
| − | </td> | + | <td>CLERK</td> |
| − | <td> | + | <td align="right">7782</td> |
| − | MILLER | + | <td>23-JAN-85</td> |
| − | </td> | + | <td align="right">1300</td> |
| − | <td> | + | <td align="right"> </td> |
| − | CLERK | + | <td align="right">10</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7782 | ||
| − | </td> | ||
| − | <td> | ||
| − | 23-JAN-85 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1300 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 10 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7788</td> |
| − | 7788 | + | <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"> | ||
| − | 7566 | ||
| − | </td> | ||
| − | <td> | ||
| − | 16-OCT-15 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 3000 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 20 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7369</td> |
| − | 7369 | + | <td>SMITH</td> |
| − | </td> | + | <td>CLERK</td> |
| − | <td> | + | <td align="right">7902</td> |
| − | SMITH | + | <td>17-DEC-90</td> |
| − | </td> | + | <td align="right">800</td> |
| − | <td> | + | <td align="right"> </td> |
| − | CLERK | + | <td align="right">20</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7902 | ||
| − | </td> | ||
| − | <td> | ||
| − | 17-DEC-90 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 800 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 20 | ||
| − | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7844</td> |
| − | 7844 | + | <td>TURNER</td> |
| − | </td> | + | <td>SALESMAN</td> |
| − | <td> | + | <td align="right">7698</td> |
| − | TURNER | + | <td>08-SEP-81</td> |
| − | </td> | + | <td align="right">1500</td> |
| − | <td> | + | <td align="right">0</td> |
| − | SALESMAN | + | <td align="right">30 |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7698 | ||
| − | </td> | ||
| − | <td> | ||
| − | 08-SEP-81 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1500 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 0 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 30 | ||
</td> | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td align="right"> | + | <td align="right">7521</td> |
| − | 7521 | + | <td>WARD</td> |
| − | </td> | + | <td>SALESMAN</td> |
| − | <td> | + | <td align="right">7698</td> |
| − | WARD | + | <td>22-FEB-94</td> |
| − | </td> | + | <td align="right">1250</td> |
| − | <td> | + | <td align="right">500</td> |
| − | SALESMAN | + | <td align="right">30</td> |
| − | </td> | ||
| − | <td align="right"> | ||
| − | 7698 | ||
| − | </td> | ||
| − | <td> | ||
| − | 22-FEB-94 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 1250 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 500 | ||
| − | </td> | ||
| − | <td align="right"> | ||
| − | 30 | ||
| − | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
| − | |||
Revision as of 15:37, 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 |
|---|---|---|---|---|---|---|---|
| 7876 | ADAMS | CLERK | 7788 | 19-NOV-15 | 1100 | 20 | |
| 7499 | ALLEN | SALESMAN | 7698 | 20-FEB-95 | 1600 | 300 | 30 |
| 7698 | BLAKE | MANAGER | 7839 | 01-MAY-81 | 2850 | 30 | |
| 7782 | CLARK | MANAGER | 7839 | 09-JUN-89 | 2450 | 10 | |
| 7902 | FORD | ANALYST | 7566 | 03-DEC-91 | 3000 | 20 | |
| 7900 | JAMES | CLERK | 7698 | 03-DEC-81 | 950 |   | 30 |
| 7566 | JONES | MANAGER | 7839 | 02-APR-91 | 2975 | 20 | |
| 7839 | KING | PRESIDENT | 17-NOV-80 | 5000 | 10 | ||
| 7654 | MARTIN | SALESMAN | 7698 | 28-SEP-93 | 1250 | 1400 | 30 |
| 7934 | MILLER | CLERK | 7782 | 23-JAN-85 | 1300 | 10 | |
| 7788 | SCOTT | ANALYST | 7566 | 16-OCT-15 | 3000 | 20 | |
| 7369 | SMITH | CLERK | 7902 | 17-DEC-90 | 800 | 20 | |
| 7844 | TURNER | SALESMAN | 7698 | 08-SEP-81 | 1500 | 0 | 30 |
| 7521 | WARD | SALESMAN | 7698 | 22-FEB-94 | 1250 | 500 | 30 |
