If you use a productivity tool such as TOAD or SQL Developer (which is free from oracle) then you can generate insert statements at the press of a button. Do you have access to these tools? If not, you can issue the describe command from sql plus. There is also an excellent response...