1

Issue in SQL Loader scripts

view story
linux-howto

http://www.unix.com – Hi, I'm planning to load the data from FLAT files into tables. Source file: more input.txt Code: LRNO|Bale|Horsepower|NumberOfBarges|BollardPull|NumberOfCars|GasCapacity|GrainCapacity|IndicatedHorsepower|LiquidCapacity| NumberOfPassengers|NumberRefrigeratedContainers|NumberOfTEU|NumberOfTrucks|NumberOfVehicles|NumberOfRailWagons 5002170|15884|11001||0||0|17647|11001|0|4|0|40||| 5004099|19022|18151||0||0|19385|18151|0|0|0|0||| 5004245|19022|18151||0||0|19385|18151|0|0|0|0||| But when i'm opening same file through VI editor it showing new line feed character as well. Code: LRN (HowTos)