如何在创建一个表的同时创建主键和索引，给我一个例子就好

Question

CREATE TABLE C_PRO_CPVN(
                        called_procedure_name varchar2(40) NOT NULL,
                        called_procedure_ver number(3) NOT NULL,
                        status char(1) NOT NULL,
                        routing_comment varchar2(1024),
                        description varchar2(240),
                        lm_user varchar2(20),
                        lm_time date
                        ) TABLESPACE CONF_T;
ALTER TABLE C_PRO_CPVN ADD CONSTRAINT PK_C_PRO_CPVN PRIMARY KEY (called_procedure_name, called_procedure_ver)
      USING INDEX TABLESPACE CONF_I;

Answer 1

CREATE TABLE  CM_TEMP                       (
       PART_ID VARCHAR2(20),
       COST_CODE VARCHAR2(20),
       QTY NUMBER(12)
       PRIMARY KEY (PART_ID,COST_CODE)      );
CREATE INDEX IDX_CM_TEMP ON CM_TEMP(PART_ID,COST_CODE);