select * from bible where btext like '%침례%'; update bible set btext = replace(btext, '침례', '세례') where btext like '%침례%'; commit; -- 한자 성경 select * from bible where btext like '%浸禮%'; update bible set btext = replace(btext, '浸禮', '洗禮') where btext like '%浸禮%'; commit; -- 만나주석 -- 1번 select * from bible where btext like '%침례%'; update bible set btext = replace(btext, '침례', '세례') where btext like '%침례%'; commit; -- 2번 select * from bible where btext like '%浸禮%'; update bible set btext = replace(btext, '浸禮', '洗禮') where btext like '%浸禮%'; commit; -- 3번 세례(洗禮) --> 세례(洗禮, 침례(浸禮)) update bible set btext = replace(btext, '세례(洗禮, 침례(浸禮))', '세례(洗禮)') where btext like '%세례(洗禮)%'; commit; -- HebGrkKo.dct 수정할 때 사용 select * from lexicon where dtext like '%침례%'; update lexicon set dtext = replace(dtext, '침례', '세례') where dtext like '%침례%'; commit; -- 한번 더 해줘야 함(괄호부분의 순서를 바꿔줌) update lexicon set dtext = replace(dtext, '세례(세례)', '세례(침례)') where dtext like '%세례(세례)%'; commit;