1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| select
substr (rpad (nvl (replace(trim(record_type),' ','='),'='),1,'='),1,1),
substr (rpad (nvl (replace(trim(custcode),' ','='),'='),10,'='),1,10),
substr (rpad (nvl (replace(trim(usernbr),' ','='),'='),8,'='),1,8),
substr (rpad (nvl (replace(trim(username),' ','='),'='),25,'='),1,25),
substr (rpad (nvl (replace(trim(custname),' ','='),'='),25,'='),1,25),
substr (rpad (nvl (replace(trim(nwcode),' ','='),'='),4,'='),1,4),
...
substr (rpad (nvl (replace(trim(todate),' ','='),'='),10,'='),1,10),
$rfs_date,
substr (rpad (nvl (replace(trim(billdate),' ','='),'='),10,'='),1,10),
substr (rpad (nvl (replace(trim(stopdate),' ','='),'='),10,'='),1,10),
...
substr (rpad (nvl (replace(trim(COUNTRY_NAME),' ','='),'='), 35,'='),1, 35),
substr (rpad (nvl (trim(semicolon),'='),1,'='),1,1)
from TEMP_FR_011 ; -- avec eventuellement des clauses where pour filtrer |
Partager