alter table mid_paysol_limits add column ordinal_pos number(2); update mid_paysol_limits set ordinal_pos = 1 where currency_iso = 'GBP'; update mid_paysol_limits set ordinal_pos = 2 where currency_iso = 'EUR'; update mid_paysol_limits set ordinal_pos = 3 where currency_iso = 'USD'; update mid_paysol_limits set ordinal_pos = 4 where currency_iso = 'CNY'; update mid_paysol_limits set ordinal_pos = 5 where currency_iso = 'RMB'; update mid_paysol_limits set ordinal_pos = 6 where currency_iso = 'HKD'; update mid_paysol_limits set ordinal_pos = 7 where currency_iso = 'JPY'; update mid_paysol_limits set ordinal_pos = 8 where currency_iso = 'CHF'; update mid_paysol_limits set ordinal_pos = 9 where currency_iso = 'NOK'; update mid_paysol_limits set ordinal_pos = 10 where currency_iso = 'SEK'; update mid_paysol_limits set ordinal_pos = 11 where currency_iso = 'NZD'; update mid_paysol_limits set ordinal_pos = 12 where currency_iso = 'DKK'; update mid_paysol_limits set ordinal_pos = 13 where currency_iso = 'RON'; update mid_paysol_limits set ordinal_pos = 14 where currency_iso = 'TRY'; update mid_paysol_limits set ordinal_pos = 15 where currency_iso = 'CAD'; update mid_paysol_limits set ordinal_pos = 16 where currency_iso = 'ZAR'; update mid_paysol_limits set ordinal_pos = 17 where currency_iso = 'AUD'; update mid_paysol_limits set ordinal_pos = 18 where currency_iso = 'ARS'; update mid_paysol_limits set ordinal_pos = 19 where currency_iso = 'ILS'; update mid_paysol_limits set ordinal_pos = 20 where currency_iso = 'THB'; update mid_paysol_limits set ordinal_pos = 21 where currency_iso = 'KRW'; update mid_paysol_limits set ordinal_pos = 22 where currency_iso = 'HUF'; update mid_paysol_limits set ordinal_pos = 23 where currency_iso = 'MYR'; update mid_paysol_limits set ordinal_pos = 24 where currency_iso = 'TWD'; update mid_paysol_limits set ordinal_pos = 25 where currency_iso = 'SGD';