Difference between revisions of "OracleSampleData"

From mi-linux
Jump to navigationJump to search
Line 2: Line 2:
  
 
<h3>DEPT Table</h3>
 
<h3>DEPT Table</h3>
−
<table>
+
<table border="1">
 
<th>DEPTNO</th><th>DNAME</th><th>LOC</th>
 
<th>DEPTNO</th><th>DNAME</th><th>LOC</th>
 
<tr><td>10</td><td>ACCOUNTING</td><td> NEW YORK</td></tr>
 
<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>20</td><td>RESEARCH</td><td>DALLAS</td></tr>
−
<tr><td>30</td><td>SALES </td><td>       CHICAGO</td></tr>
+
<tr><td>30</td><td>SALES</td><td>CHICAGO</td></tr>
−
<tr><td>40</td><td>OPERATIONS BOSTON</td></tr>
+
<tr><td>40</td><td>OPERATIONS</td><td>BOSTON</td></tr>
 
</table>
 
</table>

Revision as of 15:11, 9 January 2016

Sample DataSet

DEPT Table

DEPTNODNAMELOC
10ACCOUNTING NEW YORK
20RESEARCHDALLAS
30SALESCHICAGO
40OPERATIONSBOSTON
Retrieved from "https://mi-linux.wlv.ac.uk/wiki/index.php?title=OracleSampleData&oldid=8345"