--创建视图
CREATE TABLE vendor_master(
VID int NOT NULL PRIMARY KEY,
VNAME VARCHAR2(8)NOT NULL,
VENADD1 VARCHAR2(8) NOT NULL,
VENADD2 VARCHAR2(8) NOT NULL,
VENADD3 VARCHAR2(8) NOT NULL
);
CREATE VIEW VENADDRES
AS
SELECT v.VENADD1,v.VENADD2,v.VENADD3
FROM vendor_master v;
SELECT * FROM VENADDRES;
--创建序列
CREATE SEQUENCE SEQ_my_seq
START WITH 1000
INCREMENT BY 10
MAXVALUE 1100
MINVALUE 1000
CYCLE
NOCACHE;
select SEQ_my_seq.nextval from dual;
--创建索引
CREATE TABLE order_detail(
OID int NOT NULL PRIMARY KEY,
ORDERNO VARCHAR2(8)NOT NULL,
ITEMCODE VARCHAR2(8) NOT NULL,
CUSTOMERID VARCHAR2(8) NOT NULL,
CUSTOMADDR VARCHAR2(8) NOT NULL
);
CREATE UNIQUE INDEX x_ord ON order_detail(orderno,itemcode)
--TABLESPA
CREATE TABLE vendor_master(
VID int NOT NULL PRIMARY KEY,
VNAME VARCHAR2(8)NOT NULL,
VENADD1 VARCHAR2(8) NOT NULL,
VENADD2 VARCHAR2(8) NOT NULL,
VENADD3 VARCHAR2(8) NOT NULL
);
CREATE VIEW VENADDRES
AS
SELECT v.VENADD1,v.VENADD2,v.VENADD3
FROM vendor_master v;
SELECT * FROM VENADDRES;
--创建序列
CREATE SEQUENCE SEQ_my_seq
START WITH 1000
INCREMENT BY 10
MAXVALUE 1100
MINVALUE 1000
CYCLE
NOCACHE;
select SEQ_my_seq.nextval from dual;
--创建索引
CREATE TABLE order_detail(
OID int NOT NULL PRIMARY KEY,
ORDERNO VARCHAR2(8)NOT NULL,
ITEMCODE VARCHAR2(8) NOT NULL,
CUSTOMERID VARCHAR2(8) NOT NULL,
CUSTOMADDR VARCHAR2(8) NOT NULL
);
CREATE UNIQUE INDEX x_ord ON order_detail(orderno,itemcode)
--TABLESPA