데이터베이스 질문과 답변
A열
1,3000
1,4650
1,3000
이있는데요 .. 이 , 표 를 없애려고 합니다
결과:
A열
13000
14650
13000
이렇게 update 못하나요??
by proud
[2010.04.04 15:08:46]
15:08:09 SQL> create table test_update
15:08:10 2 as
15:08:10 3 select '1,3000' a from dual union all
15:08:10 4 select '1,4650' a from dual union all
15:08:10 5 select '1,3000' a from dual
15:08:10 6 /
Table created.
Elapsed: 00:00:00.48
15:08:10 SQL>
15:08:10 SQL> update test_update
15:08:10 2 set a = replace(a,',')
15:08:10 3 ;
3 rows updated.
Elapsed: 00:00:00.01
15:08:10 SQL>
15:08:10 SQL> commit;
Commit complete.
Elapsed: 00:00:00.00
15:08:10 SQL>
15:08:11 SQL> select * from test_update;
A
------------
13000
14650
13000
Elapsed: 00:00:00.03
15:08:10 2 as
15:08:10 3 select '1,3000' a from dual union all
15:08:10 4 select '1,4650' a from dual union all
15:08:10 5 select '1,3000' a from dual
15:08:10 6 /
Table created.
Elapsed: 00:00:00.48
15:08:10 SQL>
15:08:10 SQL> update test_update
15:08:10 2 set a = replace(a,',')
15:08:10 3 ;
3 rows updated.
Elapsed: 00:00:00.01
15:08:10 SQL>
15:08:10 SQL> commit;
Commit complete.
Elapsed: 00:00:00.00
15:08:10 SQL>
15:08:11 SQL> select * from test_update;
A
------------
13000
14650
13000
Elapsed: 00:00:00.03
by 러드
[2010.04.05 09:22:59]
UPDATE TABLE SET A = REPLACE(A, ',' ) 이렇게
by 러드
[2010.04.05 09:24:10]
술을 많이 먹었나;;; 위에분이 잘 알려 주셨네 ㅠㅠ
by 이교숙
[2010.04.05 15:54:53]
update 테이블명
set A열 = replace(A열, ',', '') ;
set A열 = replace(A열, ',', '') ;
) 버튼을 클릭하여 작성 하시면 됩니다.