Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (col2 number)
insert into test values (123)
1 rows affected

select * from test

COL2

123

alter table test 
add col1 number generated always as identity (start with 1 increment by 1)
select * from test

COL2
COL1

123
1