alter table abc add column c varchar(10);

为什么有column就错误，
alter table abc add c varchar(10);就是对的

---

引用

为什么有column就错误，
alter table abc add c varchar(10);就是对的

add不用加column
如果是drop 就要用到!
alter table abc drop column c

---

语法要求，如此

建立可以看看这个贴子
“很全的help.sql Oracle的sqlplus环境下的帮助系统”

---

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> help alter user;

ALTER USER
----------

Use this command to change any of the following characteristics of a
database user:

  *  authentication mechanism of the user
  *  password
  *  default tablespace for object creation
  *  tablespace for temporary segments created for the user
  *  tablespace access and tablespace quotas
  *  limits on database resources
  *  default roles

ALTER USER user
  { IDENTIFIED {BY password | EXTERNALLY
                | GLOBALLY AS 'CN=user'}
  | DEFAULT TABLESPACE tablespace
  | TEMPORARY TABLESPACE tablespace
  | QUOTA { integer [K | M] | UNLIMI