注意:创建表时字段上绝对不能加双引号,像这样: “ id” VARCHAR2(32) not null,会报ORA-00904 标识符无效
下面是正确的,在plsql中可以执行
//注意字段上不可以加双引号-zhaoyan 2013.07.26 10:24
drop table WS_STEP_INSTANCE cascade constraints;
/*==============================================================*/
/* Table: WS_STEP_INSTANCE */
/*==============================================================*/
create table WS_STEP_INSTANCE (
id VARCHAR2(32) not null,
ws_id VARCHAR2(32) not null,
proc_inst VARCHAR2(32) not null,
step_name VARCHAR2(32) not null,
sheet_type VARCHAR2(8) not null,
sheet_code VARCHAR2(32) not null,
sheet_biz_status VARCHAR2(8) not null,
sheet_submit_way VARCHAR2(8) not null,
task_id NUMBER(19) not null,
handler_code VARCHAR2(32),
handler_dept VARCHAR2(32),
handler_role VARCHAR2(32),
sheet_transfer_type VARCHAR2(8) not null,
parent_id VARCHAR2(32),
prealarm_times INTEGER,
reminder_times INTEGER,
search_times INTEGER,
sheet_time_status VARCHAR2(8),
dispatch_time DATE,
receive_time DATE,
complete_time DATE,
constraint PK_WS_STEP_INSTANCE primary key ("id")
);