|
|
| (One intermediate revision 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>
| |
| − | The following represents the intial data inserted by the SQLLoad command.
| |
| | | | |
| − | <h3 style= "color:blue">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 style= "color:blue">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 style= "color:blue">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 style= "color:blue">CUSTOMER Table</h3>
| |
| − | <table class=customer cellspacing=0 border = "1" width= "50%">
| |
| − | <tr>
| |
| − | <th scope="col">CNO</th>
| |
| − | <th scope="col">ORDERDATE</th>
| |
| − | <th scope="col">NAME</th>
| |
| − | <th scope="col">CITY</th>
| |
| − | <th scope="col">COUNTRY</th>
| |
| − | <th scope="col">PNO</th>
| |
| − | <th scope="col">DESCRIPTION</th>
| |
| − | <th scope="col">QTY</th>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">1</td><td>01-JAN-97</td><td>J BOND</td><td>STOCKPORT</td><td>ENGLAND</td>
| |
| − | <td align="right">1</td><td>BONNET</td><td align="right">20</td>
| |
| − | </tr>
| |
| − | <tr><td align="right">1</td><td>11-JUN-97</td><td>J BOND</td><td>STOCKPORT</td><td>ENGLAND</td>
| |
| − | <td align="right">2</td><td>WIDGET</td><td align="right">10</td></tr>
| |
| − | <tr>
| |
| − | <td align="right">1</td><td>21-APR-98</td><td>J BOND</td><td>STOCKPORT</td><td>ENGLAND</td>
| |
| − | <td align="right">1</td><td>BONNET</td><td align="right">40</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">1</td><td>15-AUG-98</td><td>J BOND</td><td>STOCKPORT</td><td>ENGLAND</td>
| |
| − | <td align="right">3</td><td>PAINT: WHITE</td><td align="right">4</td></tr>
| |
| − | <tr>
| |
| − | <td align="right">2</td><td>22-APR-96</td><td>B TURPIN</td><td>MANCHESTER</td><td>ENGLAND</td>
| |
| − | <td align="right">2</td><td>WIDGETS</td><td align="right">41</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">2</td><td>11-JUN-97</td><td>B TURPIN</td><td>MANCHESTER</td><td>ENGLAND</td>
| |
| − | <td align="right">1</td><td>BONNET</td><td align="right">1</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">3</td><td>06-FEB-96</td><td>I PERRY</td><td>WOLVERHAMPTON</td><td>ENGLAND</td>
| |
| − | <td align="right">5</td><td>NAILS</td><td align="right">60</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">3</td><td>17-NOV-97</td><td>I PARRY</td><td>WOLVERHAMPTON</td><td>ENGLAND</td>
| |
| − | <td align="right">3</td><td>PAINT: WHITE</td><td align="right">2</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">4</td><td>14-JUL-97</td><td>P FOLWER</td><td>BIRMINGHAM</td><td>ENGLAND</td>
| |
| − | <td align="right">6</td><td>HAMMER</td><td align="right">1</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">4</td><td>30-MAY-99</td><td>P FOLWER</td><td>BIRMIGNAM</td><td>ENGLAND</td>
| |
| − | <td align="right">7</td><td>PAINT: BLUE</td><td align="right">2</td>
| |
| − | </tr>
| |
| − | <tr>
| |
| − | <td align="right">4</td><td>28-AUG-00</td><td>P FOLWER</td><td>BIRMINGHAM</td><td>UNITED KINGDOM</td>
| |
| − | <td align="right">11</td><td>WIDGET</td><td align="right">40</td>
| |
| − | </tr>
| |
| − | </table>
| |
