数据库中对年月日的处理
1、脚本
--创建DEPT表
DROP TABLE DEPT;
CREATE TABLE DEPT (
DEPTNO NUMERIC(2) NOT NULL PRIMARY KEY,
DNAME VARCHAR(14),
LOCA VARCHAR(13)
);
INSERT INTO DEPT VALUES( 10 , 'ACCOUNTING' , 'NEW YORK');
INSERT INTO DEPT VALUES( 20 , 'RESEARCH' , 'DALLAS');
INSERT INTO DEPT VALUES( 30 , 'SALES' , 'CHICAGO');
INSERT INTO DEPT VALUES( 40 , 'OPERATIONS' , 'BOSTON');
SELECT * FROM DEPT;
--创建EMP表
DROP TABLE EMP;
CREATE TABLE EMP(
EMPNO NUMERIC(4) NOT NULL PRIMARY KEY ,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR NUMERIC(4),
HIREDATE DATE ,
SAL NUMERIC(7,2) ,
SEX CHAR(6) CHECK(SEX IN ('MALE','FEMALE')),
DEPTNO NUMERIC(2) ,
FOREIGN KEY(DEPTNO) REFERENCES DEPT(DEPTNO) ON
DELETE CASCADE
);
INSERT INTO EMP VALUES
(7369, 'SMITH','CLERK' , 7902, to_date('1980-12-17', 'yyyy-mm-dd') ,
800.00 , 'MALE', 20);
INSERT INTO EMP VALUES
( 7499, 'ALLEN','SALESMAN', 7698, to_date('1981-2-20', 'yyyy-mm-dd') ,
1600.00 ,'FEMALE', 30);
INSERT INTO EMP VALUES
( 7521, 'WARD', 'SALESMAN', 7698, to_date('1981-2-22','yyyy-mm-dd') ,
评论0
最新资源