drop table tmp_aaa
;
commit;
create table tmp_aaa
( aaa char(1)
)
;
insert into tmp_aaa values ('1');
insert into tmp_aaa values ('2');
insert into tmp_aaa values ('3');
commit;
alter table tmp_lcw_aaa add bbb int;
commit;
select * from tmp_aaa
bbb에 195값이 들어갑니다
(결과)
aaa bbb
1 195
2 195
3 195
4 195
5 195
|