---创建表---
create table PSS_compPlan(compPlanID Varchar2(10),taskName Varchar2(50),taskContent Varchar2(4000),completeTime Number,accessories CLOB,isDone Number);
出现如下错误:
ERROR 位于第 1 行:
ORA-22866: default character set is of varying width
在线候教!
create table PSS_compPlan(compPlanID Varchar2(10),taskName Varchar2(50),taskContent Varchar2(4000),completeTime Number,accessories CLOB,isDone Number);
出现如下错误:
ERROR 位于第 1 行:
ORA-22866: default character set is of varying width
在线候教!
SQL> create table PSS_compPlan
2 (compPlanID Varchar2(10),
3 taskName Varchar2(50),
4 taskContent Varchar2(4000),
5 completeTime Number,
6 accessories CLOB,
7 isDone Number);表已创建。已用时间: 00: 00: 00.30
SQL> desc pss_compPlan;
名称 空? 类型
----------------------------------------- -------- ----------------------------
COMPPLANID VARCHAR2(10)
TASKNAME VARCHAR2(50)
TASKCONTENT VARCHAR2(4000)
COMPLETETIME NUMBER
ACCESSORIES CLOB
ISDONE NUMBER