Hello,

I need to add a single value such as 2004 for a newly added column in
a production data table. I got several ascii data files distinguished
by year and would like to load all of those into a single Oracle
table. Each year, there are about 100,000 rows. So I need to create a
column called YEAR and intert the Year value for each year's data. How
can I do this?

I appreciate your help.

Thanks

ning_1898 (AT) yahoo (DOT) com (David) wrote in message news:<37032184.0406011301.62bbaa06 (AT) posting (DOT) google.com>...
I find the solution for myself. I can first load the data into a table
without the newly added column and then use insert into command to
insert the data into the new table. In the insert values add the
constant value, such as 2004. It will work.