I have below table layout and I want to insert flat file into below table via SQL loader. this file is pipe delimited file. now my question is how I can load value for column - COL_3 ? as my requirement is inserted value should be date which is extracted from file name and it is not going be inside file as record. so can I extract value from file name and pass it as parameter via loading data into table ?
| COLUMN NAME | ID | PK | NULL? | DATA TYPE | DEFAULT | VALUES |
| COL_1 | 1 | | N | DATE/TIME | TIMESTAMP(6) | |
| COL_2 | 2 | | Y | DATE/TIME | TIMESTAMP(6) | |
| COL_3 | 3 | 1 | N | DATE | | Date extracted from File Name |
| COL_4 | 4 | 2 | N | VARCHAR2 (100 Byte) | | |
| COL_5 | 4 | | N | VARCHAR2 (500 Byte) | | |