CREATE TABLE BATCH_TEMP
( BATCH_ID NUMBER,
FILENAME VARCHAR2(500 BYTE)
);
CTL File
OPTIONS (MULTITHREADING =TRUE,DIRECT=TRUE)
load data append into table batch_temp FIELDS TERMINATED BY '*#'
trailing nullcols
(BATCH_ID,
FILENAME "TRIM (:FILENAME)",
STATUS
)
TEMP.DAT
403 |#24, southee street ,lawn garden | 457466 | louis | 1541669 | 75.583139 | D |*#A*#
SELECT * FROM BATCH_TEMP;
Result i'm getting
| BATCH_ID | FILE | STATUS |
| 1 | #24, southee street ,lawn garden| 457466 | louis | 1541669 |77.434076| D | A |
ACCEPTED OUTPUT --NO SPACE SHOULD BE ALLOWED LEFT AND RIGHT SIDE OF PIPE
| BATCH_ID | FILE | STATUS |
| 1 | #24, southee street ,lawn garden|457466|louis|1541669|77.434076|D | A |
Please help