- 论坛徽章:
- 0
|
SQL*Plus: Release 11.1 Production on Sat Mar 31 10:17:13 2012
SQL> conn t3/abc
Connected.
SQL> CREATE TABLE plants
( plant_id NUMBER PRIMARY KEY,
common_name VARCHAR2(15) ); 2 3
Table created.
SQL> INSERT INTO plants VALUES (1, 'African Violet');
1 row created.
SQL> ALTER TABLE plants ADD (select VARCHAR2(40) );
ALTER TABLE plants ADD (select VARCHAR2(40) )
*
ERROR at line 1:
ORA-00904: : invalid identifier
SQL> select * from plants; -----------上面的DDL错误后,应该会自动产生一个ROLLBACK吧,为什么还能查到数据?
PLANT_ID COMMON_NAME
---------- ------------------------------
1 African Violet
SQL> rollback; -------------------还得手工地ROLLBACK,这是为什么
Rollback complete.
SQL> select * from plants;
no rows selected
SQL> |
|