emp_swm 表创建与插入数据
CREATE TABLE emp_swm(
empno NUMBER (4 ),
ename VARCHAR (10 ),
job VARCHAR (9 ),
mgr NUMBER (4 ),
hiredate DATE ,
sal NUMBER (7 ,2 ),
comm NUMBER (7 ,2 ),
deptno NUMBER (2 ,0 )
)
给emp_swm表中 添加数据
INSERT INTO emp_swm VALUES (7369 ,’SMITH’,’CLERK’,7902 ,to_date(‘17 -12 -1980 ’,’dd-mm-yyyy’),800 ,NULL ,20 );
INSERT INTO emp_swm VALUES (7499 ,’ALLEN’,’SALESMAN’,7698 ,to_date(‘20 -2 -1981 ’,’dd-mm-yyyy’),1600 ,300 ,30 );
INSERT INTO emp_swm VALUES (7521 ,’WARD’,’SALESMAN’,7698 ,to_date(‘22 -2 -1981 ’,’dd-mm-yyyy’),1250 ,500 ,30 );
INSERT INTO emp_swm VALUES (7566 ,’JONES’,’MANAGER’,7839 ,to_date(‘2 -4 -1981 ’,’dd-mm-yyyy’),2975 ,NULL ,20 );
INSERT INTO emp_swm VALUES (7654 ,’MARTIN’,’SALESMAN’,7698 ,to_date(‘28 -9 -1981 ’,’dd-mm-yyyy’),1250 ,1400 ,30 );
INSERT INTO emp_swm VALUES (7698 ,’BLAKE’,’MANAGER’,7839 ,to_date(‘1 -5 -1981 ’,’dd-mm-yyyy’),2850 ,NULL ,30 );
INSERT INTO emp_swm VALUES (7782 ,’CLARK’,’MANAGER’,7839 ,to_date(‘9 -6 -1981 ’,’dd-mm-yyyy’),2450 ,NULL ,10 );
INSERT INTO emp_swm VALUES (7788 ,’SCOTT’,’ANALYST’,7566 ,to_date(‘19 -4 -87 ’,’dd-mm-yyyy’),3000 ,NULL ,20 );
INSERT INTO emp_swm VALUES (7839 ,’KING’,’PRESIDENT’,NULL ,to_date(‘17 -11 -1981 ’,’dd-mm-yyyy’),5000 ,NULL ,10 );
INSERT INTO emp_swm VALUES (7844 ,’TURNER’,’SALESMAN’,7698 ,to_date(‘8 -9 -1981 ’,’dd-mm-yyyy’),1500 ,0 ,30 );
INSERT INTO emp_swm VALUES (7876 ,’ADAMS’,’CLERK’,7788 ,to_date(‘23 -5 -87 ’,’dd-mm-yyyy’),1100 ,NULL ,20 );
INSERT INTO emp_swm VALUES (7900 ,’JAMES’,’CLERK’,7698 ,to_date(‘3 -12 -1981 ’,’dd-mm-yyyy’),950 ,NULL ,30 );
INSERT INTO emp_swm VALUES (7902 ,’FORD’,’ANALYST’,7566 ,to_date(‘3 -12 -1981 ’,’dd-mm-yyyy’),3000 ,NULL ,20 );
INSERT INTO emp_swm VALUES (7934 ,’MILLER’,’CLERK’,7782 ,to_date(‘23 -1 -1982 ’,’dd-mm-yyyy’),1300 ,NULL ,10 );
–提交
COMMIT
DESC emp_swm
SELECT * FROM emp_swm
dept_swm表创建与插入数据
CREATE TABLE dept_swm(
deptno NUMBER (2 ,0 ),
dname VARCHAR (14 BYTE),
loc VARCHAR (13 BYTE)
)
给dept_swm中 添加数据
INSERT INTO dept_swm VALUES
(10 ,’ACCOUNTING’,’NEW YORK’);
INSERT INTO dept_swm VALUES
(20 ,’RESEARCH’,’DALLAS’);
INSERT INTO dept_swm VALUES
(30 ,’SALES’,’CHICAGO’);
INSERT INTO dept_swm VALUES
(40 ,’OPERATIONS’,’BOSTON’);
–提交
COMMIT
DESC dept_swm
SELECT * FROM dept_swm
练习表 sales_tab_swm
CREATE TABLE sales_tab_swm(
year_id NUMBER NOT NULL ,
month_id NUMBER NOT NULL ,
day_id NUMBER NOT NULL ,
sales_value NUMBER (10 ,2 ) NOT NULL
);
随机插入1000条数据
INSERT INTO sales_tab
SELECT TRUNC(DBMS_RANDOM.value (2010 ,2012 )) AS year_id,
TRUNC(DBMS_RANDOM.value (1 ,13 )) AS month_id,
TRUNC(DBMS_RANDOM.value (1 ,32 )) AS day_id,
TRUNC(DBMS_RANDOM.value (1 ,100 )) AS sales_value
FROM dual
CONNECT BY level <=1000 ;
COMMIT