반응형
ORACLE 데이터 글자 교체 쿼리
select replace(dpt_name, '신세계',''), dpt_name
from ecf_dept
where dpt_name like '%신세계%';
update ecf_dept
set dpt_name = replace(dpt_name, '신세계','')
where dpt_name like '%신세계%';
반응형
ORACLE 데이터 글자 교체 쿼리
select replace(dpt_name, '신세계',''), dpt_name
from ecf_dept
where dpt_name like '%신세계%';
update ecf_dept
set dpt_name = replace(dpt_name, '신세계','')
where dpt_name like '%신세계%';