Question

求一个sql语句创建表的例子，带索引的那种，希望详细点谢谢

Answer 1

CREATE TABLE WAREHOUSE (
WAREHOUSE_ID NUMBER NOT NULL,
WAREHOUSE_NAME VARCHAR2(100),
WAREHOUSE_CODE VARCHAR2(20) NOT NULL,
ADDRESS_ID NUMBER,
CREATED_DATE DATE,
CREATED_BY VARCHAR2(100),
UPDATED_DATE DATE,
UPDATED_BY VARCHAR2(100),
STATUS CHAR(1),
CONSTRAINT PK_WAREHOUSE PRIMARY KEY (WAREHOUSE_ID)
);