Home » SQL & PL/SQL » SQL & PL/SQL » Range data loading
Range data loading [message #8140] Tue, 29 July 2003 20:50
MM
Messages: 27
Registered: July 2002
Junior Member
Hi

I am trying to load data based on a range of values. My loading looks similar to the example i'm quoting.

High_range = 0024
Low_range = 0001
Equipment_type = 'SLC2000'
T1 = 1-2
T2 = 1-9 and 14-21
T3 = 1-24

My data looks like this.
High_range Low_range T1 T2 T3
0024 0001 1 2 8
0048 0025 2 3 2
For a given equipment_type between 'High_range' and 'Low_range' I should be loop through each range one by one and for T1's 1 and T2's 2 load T3's 8 to 24 like (8,9,10 ... 24) and for the next ranges and so forth.

I hope i have explained the problem with the example,
Thanks in advance

MM
Previous Topic: sqlloader
Next Topic: Question on indexes
Goto Forum:
  


Current Time: Tue Apr 23 23:24:36 CDT 2024