Oracle Scott user data table

SQL > select * from sqlplus; select * from sqlplus;

select * from tab;
Copy the code

2. If you want to see the structure of each table, use:

descTable name;Copy the code

Scott: Dept., Salgrade, Salgrade, Salgrade, Bonus, Salgrade, Salgrade, Salgrade

• In terms of realistic relationship: there will be multiple employee information under a department;

4. [Department Table]desc dept;







5. [Employee Table]desc emp;







6. [Salary scale]desc salgrade;







7. [Payroll]desc bonus;There is no data in this table;

• Once you learn complex queries, you must master all of the above table structures.