I know I can load them in to a temporary table, then load what I want in to my actual table but is there a way I can do it without using a temporary table. The positions(character) are not allways the same so I can't use the positioning thing. But the positions are always the same with respect to the tabs. Even if the fields are empty the tabs are still there.
The script for loaidng tab delimited can be written as follows: It works good for me
-- Loads data even though few fileds are null values.
-- make sure the tempraray table columns data types length match with the raw data file
-- NULLIF is used to let the field be null if a particular field has a null value
-- x'09' is used for tab delimiting
-- below are few sample coloumns
-- a temprary table should be created in oracle with appropriate data types and length matching the tab delimted text field.