oracle 创建和插入一个表的举例

最新推荐文章于 2022-10-09 10:18:04 发布

最新推荐文章于 2022-10-09 10:18:04 发布 · 82 阅读

文章标签：

#数据库

本文详细介绍了如何在数据库中创建'emp'表并插入员工数据，包括员工编号、姓名、职位、经理编号、入职日期、薪资和部门编号。

1、创建

create table emp (empno number(4) constraint EMP_pk primary key, ename varchar2(9), job varchar2(9), mgr number(4), hiredate date, sal number(7,2), comm number(7,2), deptno number(2) constraint EMP_PK_DEPTNO references DEPT(deptno) );

2、插入

insert into emp(empno,ename,job,mgr,hiredate,sal,deptno) values(7369,'smith','clerk',7902,'17-DEC-80',800,20); insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7499,'allen','salseman',7698,'20-FEB-81',1600,300,30); insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7521,'WARD','salseman',7698,'22-FEB-81',1250,500,30); insert into emp(empno,ename,job,mgr,hiredate,sal,deptno) values(7566,'JONES','MANAGER',7839,'02-APR-81',2975,20); insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7645,'MARTIN','SALESMAN',7698,'28-SEP-81',1250,1400,20); insert into emp(empno,ename,job,mgr,hiredate,sal,deptno) values(7698,'BLACK','MANAGER',7839,'01-MAY-81',2850,20); insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7844,'URNER','SALESMAN',7698,'08-SEP-81',1500,0,20);