Oracle Note (iii) Table structure for Scott users

Oracle Notes (iii) Scott User's Table structure

In Oracle's learning, the focus is on SQL statements, and all SQL statements are done under the Scott user, who has a total of four tables that can be used:

SELECT * from Tab;

To see the names of all data tables, if you want to know the table structure of each table now, you can do this with the following command:

DESC table name;

1, Department table: Dept

№	Name	Type	Describe
1	DEPTNO	Number (2)	Represents the department number, consisting of two digits
2	Dname	VARCHAR2 (14)	Department name, up to a maximum of 14 characters
3	LOC	VARCHAR2 (13)	Where the department is located

2. Employee table: EMP

№	Name	Type	Describe
1	EMPNO	Number (4)	Number of employees, consisting of four digits
2	Ename	VARCHAR2 (10)	The name of the employee, consisting of a 10-character
3	JOB	VARCHAR2 (9)	Position of employee
4	MGR	Number (4)	Employee corresponding leader number, the leader is also an employee
5	HireDate	DATE	Employee's employment date
6	SAL	Number (7,2)	Base pay, which has two decimal places, five times times integers, altogether seven bits
7	COMM	Number (7,2)	Bonuses, commissions
8	DEPTNO	Number (2)	Department number where the employee is located

3. Salary scale: Salgrade

№	Name	Type	Describe
1	GRADE	Number	Level of wages
2	Losal	Number	Minimum wage at this level
3	Hisal	Number	Maximum wage at this level

4. Salary Table: Bonus

№	Name	Type	Describe
1	Ename	VARCHAR2 (10)	Employee Name
2	JOB	VARCHAR2 (9)	Employee positions
3	SAL	Number	Wages of employees
4	COMM	Number	Bonuses for employees

Oracle Note (iii) Table structure for Scott users