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