In Oracle learning, the focus is on the learning of SQL statements, and all SQL statements are done under the Scott user.

It is necessary to familiarize yourself with the four tables under this user.

View all table names:

SELECT * FROM tab;

To view the structure of each table:

DESC 表名称；

1, Department table: Dept

No Name type description

1 DEPTNO Number (2) department numbers, two digits.

2 dname VARCHAR2 (14) department name, up to 14 characters

3 LOC VARCHAR2 (13) Department location

2. Employee table: EMP

No Name type description

1 EMPNO numer (4) The employee's number, which consists of four digits

2 ename VARCHAR2 (10) The name of the employee, consisting of four characters

3 Job VARCHAR2 (9) Position of employee

4 MGR Numer (4) The number of the employee-corresponding leader, the leader is also an employee

5 HireDate Date Employee's employment time

6 SAL Number (7,2) base pay, two decimal places, five-bit integers. A total of seven digits.

7 COMM Numer (7,2) bonus, commission.

8 DEPTNO Numer (2) The department number where the employee is located.

3. Payroll Registration Form: Salgrade

No Name type description

1 GRADE Number Salary level

2 losal number minimum wage for this level

3 Hisal Number The maximum wage for this level.

4. Salary Table

No Name type description

1 ename VARCHAR2 (10) Employee name

2 Job VARCHAR2 (9) Employee positions

3 SAL number Employee's salary

4 COMM number Employee's bonus

In Oracle learning, the focus is on the learning of SQL statements, and all SQL statements are done under the Scott user.