Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/11/12(17:01) from 210.93.7.52 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2793 , ÁÙ¼ö : 9 |
[Oracle] replace ÇÔ¼ö »ç¿ë¹ý (°ø¹éÁ¦°Å) |
---|
1. °ø¹é¾ø¾Ö±â $ update table_name set column_name=replace(column_name,' ',''); $ update table_name set column_name=replace(column_name,' ','') where replace(column_name,' ', '')=' abc '; |