oracle中有张表test
如表:
[table]
|字段名|
|AA|
|AB|
|AC|
[/table]
怎么用正则表达式查出AB,AC而不查出AA?
就是select * from test where regexp_like(字段名,[color=red]'^(.{1})\1$'[/color]) 的红色部分怎么写?
SQL> select * from TEST20110221;
AA
AB
AC
SQL> select * from TEST20110221 where not regexp_like(name,'(.)\1');
AB
AC
SQL> select * from test20110221;
AA
AB
AC
SQL> select * from test20110221 where regexp_like(name,'A[B-Z]');
AB
AC