>

OK.

> Try this:
>
> LOAD DATA
> INFILE *
> INSERT
> INTO TABLE test1
> FIELDS TERMINATED BY "~" TRAILING NULLCOLS
> (
> t1c1
> ,t1c2
> ,t1c3 terminated by '+'
> )
> INTO TABLE test2
> FIELDS TERMINATED BY "~" TRAILING NULLCOLS
> (
> t2c1 terminated by '+'
> ,t2c2 terminated by '+'
> )
> BEGINDATA
> 100~1467~zxc+wers+12
> 101~1477~zxd+wers+13
> 102~1487~zxe+wers+14
> 103~1497~zxf+wers+15
> 104~1507~zxg+wers+16
> 105~1517~zxh+wers+17
>
>
> Raviraj wrote:
>
>> Consider the sample data given below
>> 100~1467~zxc+wers+12
>>
>> data which were delimeted by ~ and + will go to columns
>> of two different
>> tables
>> 100 > column A of Table 1
>> 1467 > column B of Table 1
>> zxc > column C of Table 1
>> wers > column D of Table 2
>> 12 > column E of Table 2
>>
>> the problem is that the process should be automated and
>> i wanted to know
>> whether it is possible to load thro
>> sql loader without writing any intermediate script.
>>
>
> -------- Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To
> unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a
> blank email to oracledba-[Email Address Removed] Visit the
> list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell
> yer mates about http://www.farAwayJobs.com By using this
> list you agree to these
> terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page