with temp as( select '张三' name from dual union all select '李四' name from dual union all select '王五' name from dual union all select '赵六' name from dual union all select '钱七' name from dual ) select name,substr(name,1,1) from temp where substr(name,1,1) in ('张','王');
--楼主是嫌麻烦 呵呵 select name from tab_name where substr(name,1,1) in('张','李','王','赵')
with temp as(
select '张三' name from dual
union all
select '李四' name from dual
union all
select '王五' name from dual
union all
select '赵六' name from dual
union all
select '钱七' name from dual
)
select name,substr(name,1,1) from temp where substr(name,1,1) in ('张','王');
--楼主是嫌麻烦 呵呵
select name from tab_name where substr(name,1,1) in('张','李','王','赵')