?????? ??????????! ?Bronze???? vol.11 <??>
- by M.Morozumi
-------------------------------
????:
REPLACE ?????????JACK and JUE?????????J???BL??????????????BLACK and BLUE??????????????????? REPLACE ?????????????????1?????????
???:
REPLACE('JACK and JUE', 'BL', 'J')
REPLACE('JACK and JUE', 'J', 'BL')
?????????????
???????????????
-------------------------------
??
2. REPLACE('JACK and JUE', 'J', 'BL')
??
REPLACE ??? 2 ??????????????????? 3 ?????????????????
???????
Oracle Database 11g: ?? ????·????
Oracle Database 11g: ????????? I