The database for this site uses MySQL and conforms to SQL-92, the same as the scope of the Information Technology Engineer Examination.
The tables used in the exercise are configured as follows, using the same configuration as the sample tables that are created when Oracle is installed.
| Column name | Column Description | Data type |
|---|---|---|
| EMPNO | Employee Number | Number |
| ENAME | Employee Name | varchar2 |
| JOB | Job | varchar2 |
| MGR | Manager | Number |
| HIREDATE | Date of Adoption | date |
| SAL | salary | Number |
| COMM | percentage pay | Number |
| DEPTNO | Department No. | Number |
| Column name | Column Description | Data type |
|---|---|---|
| DEPTNO | Department No. | Number |
| DNAME | Department name | varchar2 |
| LOC | Location | varchar2 |
This site allows you to execute SQL on the web. The purpose of this site is to deepen your understanding and to fix in your memory by solving the practice problems on each page and actually executing the SQL that you have learned. Try executing SQL according to the following practice questions.
Click on the Execute button. The SQL (SELECT * FROM EMP) in the text input area will be executed and the execution results will be displayed below it.
Did it display well? This concludes the Introduction.