to_char(time_column,‘yyyy-mm-dd’)>'2007-01-01'
to_char(time_column,‘yyyy-mm-dd’) < sysdate
CREATE SEQUENCE Goods_shiftSum_ID
START WITH 1
MAXVALUE 99999999999999
MINVALUE 1
CYCLE;
CREATE TABLE PriceAlterM
(
PPAltNo VARCHAR2(8) NOT NULL ,
PlanDate DATE NOT NULL ,
Checker VARCHAR2(12) NULL ,
CheckDate VARCHAR2(10) NULL ,
AlterType VARCHAR2(20) NULL ,
Memo VARCHAR2(50) NULL ,
Status VARCHAR2(1) DEFAULT 0 NOT NULL ,
CONSTRAINT PK_PriceAlterM PRIMARY KEY (PPAltNo)
) ;