Oracle note (3) Scott's table structure

Oracle note (3) Scott's table structure is being studied in Oracle, focusing on SQL statements, and all SQL statements must be completed under scott, this user has a total of four tables. You can use: SELECT * FROM tab; to view the names of all data tables. If you want to know the table structure of each table, you can run the following command to complete the operation: DESC table name; 1. Department table: dept region www.2cto.com name type description 1 DEPTNONUMBER (2) indicates the Department number, composed of two digits 2DNAMEVARCHAR2 (14) department name, consists of a maximum of 14 characters 3LOCVARCHAR2 (13) Department location

2. Employee table: emp ‑ www.2cto.com name type description 1 EMPNONUMBER (4) employee ID, composed of four digits 2ENAMEVARCHAR2 (10) employee name, A 10-character position consisting of 3JOBVARCHAR2 (9) Employee position 4 MGRNUMBER (4) Employee corresponding leadership number, leadership is also employee 5HIREDATEDATE employee employment date 6 SALNUMBER (7, 2) basic salary, there are two decimal places, five times integer, a total of seven 7 www.2cto.com COMMNUMBER () prize, Commission 8 DEPTNONUMBER (2) Employee's Department number

3. salary level table: salgrade region name type description 1GRADENUMBER salary level 2LOSALNUMBER minimum wage level 3HISALNUMBER highest salary level

4. Payroll: bonus employee www.2cto.com name type description 1ENAMEVARCHAR2 (10) employee name 2JOBVARCHAR2 (9) Employee position 3SALNUMBER employee's salary 4COMMNUMBER employee's bonus