How can i restore the tablestructure and recover data when i drop table column

Question

i have some test table

create table test123(ids number,emp_name varchar(100));

next i insert 1 record into the table and commit the changes

insert into test123 values(1,'asdzxc')

after that i issue

alter table test123
drop column emp_name;

can i restore the table structure to before i drop the column and recover the data 'asdzxc' which is stored in the dropped column