problem in inserting data from flat file to Oracle using SQL loader

[kiransalu]

I am loading 5 fields to a table which are in the flat file using sql*loader.
I also need to insert default vallues for 2 other fields which are in the table but not in the flat file.(SYSDATE and a constant)
how should i do that?

Expecting earlier reply.

 

[LKBrwnDBA]

Maybe you should read the manual.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[dbomrrsm]

Now thats a useful reply !!!!

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[LKBrwnDBA]

This question is on basic concepts, the time it took to initiate this thread would be the same as the time it would take to look it up in the manual.

No use repeating what can easyly be obtained just by reading the manual.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb