create table test_daigli ( id number(8) primary key, name varchar(8) ); alter table test_daigli modify name varchar(32); commit; insert into test_daigli(id,name)values(1,'|lf |wjm |'); insert into test_daigli(id,name)values(2,'|lf |'); commit; select * from test_daigli where name like '%|lf |%';实验了一下,是两条记录. 不知楼上是不是王建民
(
id number(8) primary key,
name varchar(8)
);
alter table test_daigli modify name varchar(32);
commit;
insert into test_daigli(id,name)values(1,'|lf |wjm |');
insert into test_daigli(id,name)values(2,'|lf |');
commit;
select * from test_daigli where name like '%|lf |%';实验了一下,是两条记录.
不知楼上是不是王建民