Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott@ORCL
SQL> select*from productinfo;
PRODUCTID PRODUCTNAME PRODUCTPRICE QUANTITY CATEGORY DESCRIPTION ORIGIN
---------- -------------------- ------------ ----------- ---------- -------------------------------------------------------------------------------- ----------
SQL> alter table productinfo add remark varchar2(200);
Table altered
SQL> alter table productinfo modify remark number(20);
Table altered
SQL> alter table productinfo drop column remark;
Table altered
SQL> alter table productinfo add remark varchar2(200),
2 modify productname varchar2(25);
alter table productinfo add remark varchar2(200),
modify productname varchar2(25)
ORA-01735: 无效的 ALTER TABLE 选项
SQL> alter table scott.productinfo add remark varchar2(200),
2 modify productname varchar2(25);
alter table scott.productinfo add remark varchar2(200),
modify productname varchar2(25)
ORA-01735: 无效的 ALTER TABLE 选项
SQL> alter table scott.productinfo add remark varchar2(200),
Connected as scott@ORCL
SQL> select*from productinfo;
PRODUCTID PRODUCTNAME PRODUCTPRICE QUANTITY CATEGORY DESCRIPTION ORIGIN
---------- -------------------- ------------ ----------- ---------- -------------------------------------------------------------------------------- ----------
SQL> alter table productinfo add remark varchar2(200);
Table altered
SQL> alter table productinfo modify remark number(20);
Table altered
SQL> alter table productinfo drop column remark;
Table altered
SQL> alter table productinfo add remark varchar2(200),
2 modify productname varchar2(25);
alter table productinfo add remark varchar2(200),
modify productname varchar2(25)
ORA-01735: 无效的 ALTER TABLE 选项
SQL> alter table scott.productinfo add remark varchar2(200),
2 modify productname varchar2(25);
alter table scott.productinfo add remark varchar2(200),
modify productname varchar2(25)
ORA-01735: 无效的 ALTER TABLE 选项
SQL> alter table scott.productinfo add remark varchar2(200),

