代码如下(plsql):
SQL> desc tb27_1
Name Type Nullable Default Comments
----- --------- -------- ------- --------
ID NUMBER(3)
GARDE NUMBER(3) Y
//id是主键
SQL> select * from tb27_1 ;
ID GARDE
---- -----
1 2
3 4
SQL> delete from tb27_1 where garde=2;
delete from tb27_1 where GRADE=2
ORA-00904: "GRADE": 标识符无效
SQL> delete from tb27_1 where id=1;
1 row deleted
自问自答了,原本以为是grade,结果是garde,觉得对键盘不够熟悉呀,够了,够了,&……*……¥……%¥@%*&()*%……¥%……