this.p={ m:2,
b:2,
loftPermalink:'',
id:'fks_094071085085088074084084082095083095085064084080081',
blogTitle:'oracle统计字符串中某个字符出现的次数',
blogAbstract:'\r\n
统计字符串中 E 出现的次数:\r\n
SELECT LENGTHB(TRANSLATE(\'ABCDEFGEFGDBE\',\'E\'||\'ABCDEFGEFGDBE\',\'E\')) FROM DUAL;
SELECT LENGTHB(\'ABCDEFGEFGDBE\')-LENGTHB(REPLACE(\'ABCDEFGEFGDBE\',\'E\',\'\')) FROM DUAL;一、语法:
TRANSLATE(string,from_str,to_str)
二、目的
返回将(所有出现的)from_str中的每个字符替换为to_str',
blogTag:'',
blogUrl:'blog/static/7943067201101022928944',
isPublished:1,
istop:false,
type:2,
modifyTime:0,
publishTime:1294640968944,
permalink:'blog/static/7943067201101022928944',
commentCount:2,
mainCommentCount:2,
recommendCount:1,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
vote:{},
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
mcon:'',
srk:-100,
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:true,
hostIntro:'分类中“我的实验室”是我在日常工作中的一些知识总结,有些写的比较匆忙,可能大家在阅读时会产生困扰,后期有时间我会重新整理编辑,谢谢大家的到访,您们的支持是我前进的动力!',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
}
{list a as x}
{if !!x}
{if x.visitorName==visitor.userName}
{else}
{/if}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
{/if}
${fn(x.visitorNickname,8)|escape}
{/if}
{/list}
{if !!a}
${fn(a.nickname,8)|escape}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{/if}
{list a as x}
{if !!x}
推荐过这篇日志的人:
{list a as x}
{if !!x}
{if !!b&&b.length>0}
他们还推荐了:
{list b as y}
{if !!y}
{/if}
{list a as x}
{if !!x}
{list a as x}
{if !!x}
{list a as x}
{if !!x}
{list a as x}
{if x_index>4}{break}{/if}
{if !!x}
${fn1(x.title,60)|escape}${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{/if}
{/list}
{list a as x}
{if !!x}
{if !!(blogDetail.preBlogPermalink)}
网易新闻
${headlines.title|escape}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
被推荐日志
最新日志
该作者的其他文章
博主推荐
随机阅读
首页推荐
{list a as x}
{if !!x}
${x.nickName|escape} 投票给
{var first_option = true;}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if} “${b[voteToOption_index]}”
{/if}
{/list}
{if (x.role!="-1") },“我是${c[x.role]}” {/if}
${fn1(x.voteTime)}
{if x.userName==''}{/if}
{/if}
{/list}