create table test (msn varchar2(10));
insert into test values ('5');
insert into test values ('6');
insert into test values ('7');
insert into test values ('error');
insert into test values ('8');
insert into test values ('9');
commit;我想用一条SQL删除掉'error'这条记录,怎样写这个SQL?
insert into test values ('5');
insert into test values ('6');
insert into test values ('7');
insert into test values ('error');
insert into test values ('8');
insert into test values ('9');
commit;我想用一条SQL删除掉'error'这条记录,怎样写这个SQL?
其中48和57分别是字符‘0’和‘9’对应的ascii码