|
|
| (4 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[OracleWorkbook|Workbook]] >> Introduction
| |
| − | <h2 style= "color:blue">Sample Data Set</h2>
| |
| | | | |
| − | <h3>DEPT Table</h3>
| |
| − | <table class=dept cellspacing=0 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>
| |
| − |
| |
| − | <h3>EMP Table</h3>
| |
| − | <p>Note some hiredates are based on the date you ran the script, so will be different to here:</p>
| |
| − | <table class=emp cellspacing=0 border = "1" width= "50%">
| |
| − | <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">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">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">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">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">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">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">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">7839</td>
| |
| − | <td>KING</td>
| |
| − | <td>PRESIDENT</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>
| |
| − | <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">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>
| |
| − | <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">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">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">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>
| |
| − | </table>
| |
| − | <h3>SALGRADE Table</h3>
| |
| − | <table class=salgrade cellspacing=0 border="1">
| |
| − | <th>GRADE</th><th>LOSAL</th><th>HISAL</th>
| |
| − | <tr><td>1</td><td>700</td><td>1200</td></tr>
| |
| − | <tr><td>2</td><td>1201</td><td>1400</td></tr>
| |
| − | <tr><td>3</td><td>1401</td><td>2000</td></tr>
| |
| − | <tr><td>4</td><td>2001</td><td>3000</td></tr>
| |
| − | <tr><td>5</td><td>3001</td><td>9999</td></tr>
| |
| − | <table>
| |
| − |
| |
| − |
| |
| − | <h3>CUSTOMER Table</h3>
| |
