Difference between revisions of "OracleSampleData"
From mi-linux
Jump to navigationJump to search| Line 167: | Line 167: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| − | <h3>SALGRADE Table</h3> | + | <h3 style= "color:blue">SALGRADE Table</h3> |
<table class=salgrade cellspacing=0 border="1"> | <table class=salgrade cellspacing=0 border="1"> | ||
<th>GRADE</th><th>LOSAL</th><th>HISAL</th> | <th>GRADE</th><th>LOSAL</th><th>HISAL</th> | ||
| Line 179: | Line 179: | ||
<h3 style= "color:blue">CUSTOMER Table</h3> | <h3 style= "color:blue">CUSTOMER Table</h3> | ||
| + | <table class=customer cellspacing=0> | ||
| + | <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> | ||
Revision as of 09:26, 11 January 2016
Main Page >> Oracle and SQL >> Workbook >> Introduction
Sample Data Set
The following represents the intial data inserted by the SQLLoad command.
DEPT Table
| DEPTNO | DNAME | LOC |
|---|---|---|
| 10 | ACCOUNTING | NEW YORK |
| 20 | RESEARCH | DALLAS |
| 30 | SALES | CHICAGO |
| 40 | OPERATIONS | BOSTON |
EMP Table
Note some hiredates are based on the date you ran the script, so will be different to here:
| 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 |
SALGRADE Table
| GRADE | LOSAL | HISAL |
|---|---|---|
| 1 | 700 | 1200 |
| 2 | 1201 | 1400 |
| 3 | 1401 | 2000 |
| 4 | 2001 | 3000 |
| 5 | 3001 | 9999 |
CUSTOMER Table
| CNO | ORDERDATE | NAME | CITY | COUNTRY | PNO | DESCRIPTION | QTY |
|---|---|---|---|---|---|---|---|
| 1 | 01-JAN-97 | J BOND | STOCKPORT | ENGLAND | 1 | BONNET | 20 |
| 1 | 11-JUN-97 | J BOND | STOCKPORT | ENGLAND | 2 | WIDGET | 10 |
| 1 | 21-APR-98 | J BOND | STOCKPORT | ENGLAND | 1 | BONNET | 40 |
| 1 | 15-AUG-98 | J BOND | STOCKPORT | ENGLAND | 3 | PAINT: WHITE | 4 |
| 2 | 22-APR-96 | B TURPIN | MANCHESTER | ENGLAND | 2 | WIDGETS | 41 |
| 2 | 11-JUN-97 | B TURPIN | MANCHESTER | ENGLAND | 1 | BONNET | 1 |
| 3 | 06-FEB-96 | I PERRY | WOLVERHAMPTON | ENGLAND | 5 | NAILS | 60 |
| 3 | 17-NOV-97 | I PARRY | WOLVERHAMPTON | ENGLAND | 3 | PAINT: WHITE | 2 |
| 4 | 14-JUL-97 | P FOLWER | BIRMINGHAM | ENGLAND | 6 | HAMMER | 1 |
| 4 | 30-MAY-99 | P FOLWER | BIRMIGNAM | ENGLAND | 7 | PAINT: BLUE | 2 |
| 4 | 28-AUG-00 | P FOLWER | BIRMINGHAM | UNITED KINGDOM | 11 | WIDGET | 40 |
