开发者

How would I change the following script to exclude user names longer than six characters long?

select count(*) from fnd_user where end_date is null or end date >= sysdate;

Thanks for your help.开发者_开发问答


select count(*)
from fnd_user
where (end_date is null or end_date >= sysdate)
and length(username) <= 6;


select count(*) from fnd_user where (end_date is null or end date >= sysdate)
and length(username) <= 6;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜