Databases Reference
In-Depth Information
10. We will create one employee for this department. Click on the + (add) buton for the
employee and then enter the following data:
Empno 1234
Ename JACK
Job MANAGER
Mgr 7499 —this number refers to an employee named ALLEN in the
SALES department (this is just a random number now. In real life,
HR will never report to a salesman)
Hiredate 1981-02-20 00:00:00.0
Sal 2000
Comm 200
Deptno —this will be 50 , which is automatically populated as we are creating
the employee for the department that has this value set as 50
Rowid —this will get generated when you save the record
What just happened?
We created a department in the DEPT table with the department number as 50 . We also
created an employee named JACK in the HR department.
 
Search WWH ::




Custom Search