sm_date.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 12 行

create table Date
(DATE_Time  DATE  PRIMARY KEY,
NAME   VARCHAR2(10), 
GIFT   VARCHAR2(50))
--ERR, DATE IS A KEY WORD OF ORACLE SO
create table SM_Date
(DATE_Time  DATE  PRIMARY KEY,
NAME   VARCHAR2(10),
GIFT   VARCHAR2(50))

INSERT INTO SM_DATE VALUES(ADD_MONTHS(SYSDATE,1),'LILI','FLOWER')