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