UC知道oracle查询语句~
来源：百度知道 编辑：UC知道 时间：2024/06/18 15:27:15
select code,id,sex from vip_card@gam
where
(length(id)=18 and to_number(substr(id,17,1)) in (1,3,5,7,9))
or
(length(id)=15 and to_number(substr(id,15,1)) in (1,3,5,7,9))
表名vip_card，code和ID为列名，ID是身份证号，求男性的code和ID
where
(length(id)=18 and to_number(substr(id,17,1)) in (1,3,5,7,9))
or
(length(id)=15 and to_number(substr(id,15,1)) in (1,3,5,7,9))
表名vip_card，code和ID为列名，ID是身份证号，求男性的code和ID
代码写的没问题，不过我觉得你那个转换没必要加：
to_number(substr(id,17,1)) in (1,3,5,7,9)改成
substr(id,17,1) in ('1','3','5','7','9')最好
select code,id from vip_card
where
(length(id)=18 and to_number(substr(id,17,1)) in (1,3,5,7,9))
or
(length(id)=15 and to_number(substr(id,15,1)) in (1,3,5,7,9))
你已经查出来了 加sex没必要了吧？
- -你这是在干嘛？代码找错？貌似没错。
rehgreh