|
|
| (19 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | <h2>Sample DataSet</h2>
| |
| | | | |
| − | <h3>DEPT Table</h3>
| |
| − | <table border="1">
| |
| − | <th>DEPTNO</th><th>DNAME</th><th>LOC</th>
| |
| − | <tr><td>10</td><td>ACCOUNTING</td><td> NEW YORK</td></tr>
| |
| − | <tr><td>20</td><td>RESEARCH</td><td>DALLAS</td></tr>
| |
| − | <tr><td>30</td><td>SALES</td><td>CHICAGO</td></tr>
| |
| − | <tr><td>40</td><td>OPERATIONS</td><td>BOSTON</td></tr>
| |
| − | </table>
| |
| − |
| |
| − | <p>
| |
| − | <table border = "1" class=emp cellspacing=0>
| |
| − | <tr>
| |
| − | <th scope="col">EMPNO</th>
| |
| − | <th scope="col">ENAME</th>
| |
| − | <th scope="col">JOB</th>
| |
| − | <th scope="col">MGR</th>
| |
| − | <th scope="col">HIREDATE</th>
| |
| − | <th scope="col">SAL</th>
| |
| − | <th scope="col">COMM</th>
| |
| − | <th scope="col">DEPTNO</th>
| |
| − | </tr>
| |
| − | <tr><td align="right">7839</td>
| |
| − | <td>KING</td>
| |
| − | <td>PRESIDENT</td>
| |
| − | <td> </td>
| |
| − | <td>17-NOV-80</td>
| |
| − | <td align="right">5000</td>
| |
| − | <td> </td>
| |
| − | <td align="right">10</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">7566</td>
| |
| − | <td>JONES</td>
| |
| − | <td>MANAGER</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>
| |
| − | <td align="right">7788</td>
| |
| − | <td>SCOTT</td>
| |
| − | <td>ANALYST</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>
| |
| − | <td align="right">7876</td>
| |
| − | <td>ADAMS</td>
| |
| − | <td>CLERK</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>
| |
| − | <td align="right">7902
| |
| − | </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><td align="right">7369</td>
| |
| − | <td>SMITH</td>
| |
| − | <td>CLERK</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>
| |
| − | <td align="right">7698</td>
| |
| − | <td>
| |
| − | BLAKE
| |
| − | </td>
| |
| − | <td>
| |
| − | MANAGER
| |
| − | </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>
| |
| − | <td align="right">
| |
| − | 7499
| |
| − | </td>
| |
| − | <td>
| |
| − | ALLEN
| |
| − | </td>
| |
| − | <td>
| |
| − | SALESMAN
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 7698
| |
| − | </td>
| |
| − | <td>
| |
| − | 20-FEB-95
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 1600
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 300
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 30
| |
| − | </td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">
| |
| − | 7521
| |
| − | </td>
| |
| − | <td>
| |
| − | WARD
| |
| − | </td>
| |
| − | <td>
| |
| − | SALESMAN
| |
| − | </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>
| |
| − | <td align="right">
| |
| − | 7654
| |
| − | </td>
| |
| − | <td>
| |
| − | MARTIN
| |
| − | </td>
| |
| − | <td>
| |
| − | SALESMAN
| |
| − | </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>
| |
| − | <td align="right">
| |
| − | 7844
| |
| − | </td>
| |
| − | <td>
| |
| − | TURNER
| |
| − | </td>
| |
| − | <td>
| |
| − | SALESMAN
| |
| − | </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>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">
| |
| − | 7900
| |
| − | </td>
| |
| − | <td>
| |
| − | JAMES
| |
| − | </td>
| |
| − | <td>
| |
| − | CLERK
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 7698
| |
| − | </td>
| |
| − | <td>
| |
| − | 03-DEC-81
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 950
| |
| − | </td>
| |
| − | <td align="right">
| |
| − |
| |
| − | </td>
| |
| − | <td align="right">
| |
| − | 30
| |
| − | </td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">
| |
| − | 7782
| |
| − | </td>
| |
| − | <td>
| |
| − | CLARK
| |
| − | </td>
| |
| − | <td>
| |
| − | MANAGER
| |
| − | </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>
| |
| − | <td align="right">
| |
| − | 7934
| |
| − | </td>
| |
| − | <td>
| |
| − | MILLER
| |
| − | </td>
| |
| − | <td>
| |
| − | CLERK
| |
| − | </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>
| |
| − | </table>
| |
