sm_date.txt

orale培训教材包括了所有的sql说明和实例

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')