oracle判断字符串以什么开头_oracle 如何查找特定字母开头的某个字段？

展开全部

1、创建测试表，

create table test_teacher(teacher_no varchar(30) , teacher_name varchar(30));

2、插入测试数据

insert into test_teacher values('T0101','陈xx');

insert into test_teacher values('0101','王xx');

insert into test_teacher values('T0133','李xx');

insert into test_teacher values('0122','朱xx');

insert into test_teacher values('T0156','张xx');

insert into test_teacher values('T0188','六xx');

commit;

3、查询表中全32313133353236313431303231363533e4b893e5b19e31333431376563量数据，select t.* from test_teacher t;

4、编写sql，找出所有的不是T开头的记录; select t.*, rowid from test_teacher t where t.teacher_no not like 'T%';