SQL Loader

[abc]

Hi
how to load data in to table which is tab delimited through sql loader.

Thanks
ABC

[balajiyes]

hi do this:

1) create table test_load_tab(account_no varchar2(100), COUNTRYCODE varchar2(100));

2)
LOAD DATA
INFILE 'c:\CTL\test_dat.DAT'
BADFILE 'c:\CTL\test_dat_bad.BAD'
DISCARDFILE 'c:\CTL\test_dat_dis.DIS'
append
INTO TABLE test_load_tab
FIELDS TERMINATED BY "CHR(9)" TRAILING NULLCOLS
(account_no,
COUNTRYCODE
)

Cheers!