Adding date to end of line in fixed length file

[paljnad]

I have a file that has data in a fixed-length format like this:

01/29/2010 INT CN
01/29/2010 NAT CN
01/29/2010 TSS CN


And I want the output to be:

01/29/2010 INT CN 08/17/2010
01/29/2010 NAT CN 08/17/2010
01/29/2010 TSS CN 08/17/2010

Basically, I would like to append current date to the end of each line of the file.

Could I do this using Oracle?

 

[Thargy]

Yes.

What methods are you using to create the current format of data and the output file? If you tell us what you have already achieved, we can probably make more informed recommendations to help.

Regards

T