Basic Oracle Database Learning (III), oracle Database

Basic Oracle Database Learning (III), oracle Database

The emp dept salgrade bunus structure of Oracle's four tables. Remember that it is helpful for later SQL statement learning.

 

Employee table (emp)
No.	Field	Type	Description
1	Empno	NUMBER (4)	Employee ID, which is unique
2	ENAME	VARCHAR2 (10)	Employee name
3	JOB	VARCHAR2 (9)	Represents a job position
4	MGR	NUMBER (4)	Indicates the employee's leadership number.
5	HIREDATE	DATA	Time of employment
6	SAL	NUMBER (7,2)	Salaries of employees
7	COMM	NUMBER (7,2)	Indicates the employee's bonus or commission
8	DEPTNO	NUMBER (2)	Department ID

 

Department table (dept)
No.	Field	Type	Description
1	DEPTNO	NUMBER (2)	Department ID, which is a unique ID
2	DNAME	VARCHAR2 (14)	Department name
3	LOC	VARCHAR2 (13)	Department location

 

Salgrade)
No.	Field	Type	Description
1	GRADE	NUMBER	Wage level
2	LOSAL	NUMBER	Minimum Wage
3	HISAL	NUMBER	Highest-grade salary

 

Bonus table (bouns)
No.	Field	Type	Description
1	ENAME	VARCHAR2 (10)	Employee name
2	JOB	VARCHAR2 (9)	Employee work
3	SAL	NUMBER	Employee Salary
4	COMM	NUMBER	Employee bonus (Commission)