oracle日语片假名转平假名函数资源-CSDN文库

共1个文件

doc：1个

4星 · 超过85%的资源需积分: 13 148 浏览量 2009-01-06 14:39:52 上传评论收藏 7KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

package

KANACONVERT.rar （1个子文件）

KANACONVERT.doc 45KB

create or replace function KANACONVERT(strInput in varchar2) return

varchar2 is

strOutput varchar2(32000);

strFindString varchar2(2);

strHiragana varchar2(2);

strHalfKatakana varchar2(200);

strFullHiragana varchar2(200);

strChrHalfKatakana varchar2(10);

strChrFullHiragana varchar2(10);

intStrlenght number;

intStrPostion number;

intRecordCount number;

intChrPostion number;

begin

--------------

変数の初期化

strHalfKatakana := 'ｶﾞｷﾞｸﾞｹﾞｺﾞｻﾞｼﾞｽﾞｾﾞｿﾞﾀﾞﾁﾞﾂﾞﾃﾞﾄﾞﾊﾞﾋﾞﾌﾞﾍﾞﾎﾞﾊﾟﾋﾟﾌﾟﾍﾟﾎﾟｳﾞ';

strFullHiragana := 'がぎぐげござじずぜぞだぢづでどばびぶべぼぱぴぷぺぽヴ';

intChrPostion := 1;

-------------------------

intStrlenght := length(strInput);

if intStrlenght>0 then

strOutput := strInput;

for i in 1..26 loop

strChrHalfKatakana := substr(strHalfKatakana,intChrPostion,2);

strChrFullHiragana := substr(strFullHiragana,i,1);

if instr(strOutput,strChrHalfKatakana) > 0 then

strOutput := replace(strOutput,strChrHalfKatakana,strChrFullHiragana);

end if;

intChrPostion:= i*2+1;

end loop;

intStrlenght := length(strOutput);

for intStrPostion in 1..intStrlenght loop

strFindString := substr(strOutput,intStrPostion,1);

select count(*),max(col1) into intRecordCount,strHiragana from (

select 'あ' col1,'アぁァｧｱ' col2 from dual union

select 'い' col1,'イぃィｨｲ' col2 from dual union

select 'う' col1,'ウぅゥｩｳ' col2 from dual union

select 'え' col1,'エぇェｪｴ' col2 from dual union

select 'お' col1,'オぉォｫｵ' col2 from dual union

select 'か' col1,'カヵｶ ' col2 from dual union

select 'き' col1,'キｷ' col2 from dual union

select 'く' col1,'クｸ' col2 from dual union

select 'け' col1,'ケヶｹ ' col2 from dual union

select 'こ' col1,'コｺ' col2 from dual union

select 'さ' col1,'サｻ' col2 from dual union

select 'し' col1,'シｼ' col2 from dual union

select 'す' col1,'スｽ' col2 from dual union

select 'せ' col1,'セｾ' col2 from dual union

select 'そ' col1,'ソｿ' col2 from dual union

select 'た' col1,'タﾀ' col2 from dual union

select 'ち' col1,'チﾁ' col2 from dual union

select 'つ' col1,'ツっッｯﾂ' col2 from dual union

select 'て' col1,'テﾃ' col2 from dual union

select 'と' col1,'トﾄ' col2 from dual union

select 'な' col1,'ナﾅ' col2 from dual union

select 'に' col1,'ニﾆ' col2 from dual union

select 'ぬ' col1,'ヌﾇ' col2 from dual union

select 'ね' col1,'ネﾈ' col2 from dual union

select 'の' col1,'ノﾉ' col2 from dual union

select 'は' col1,'ハﾊ' col2 from dual union

select 'ひ' col1,'ヒﾋ' col2 from dual union

select 'ふ' col1,'フﾌ' col2 from dual union

select 'へ' col1,'ヘﾍ' col2 from dual union

select 'ほ' col1,'ホﾎ' col2 from dual union

select 'ま' col1,'マﾏ' col2 from dual union

select 'み' col1,'ミﾐ' col2 from dual union

select 'む' col1,'ムﾑ' col2 from dual union

select 'め' col1,'メﾒ' col2 from dual union

select 'も' col1,'モﾓ' col2 from dual union

内容反馈

z28834670

2013-02-19

非常实用的一个功能，可以在阅读上帮助到不少。

Craftsman

粉丝: 2
资源: 4

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip