Может кому пригодится, данный select был написан для oracla.
Вбиваем необходимый ID SC,получаем путь к файлу на ftp ресурсе
000/000/000/000/000/000/010/00b/5e9/6d8/b5/00000000-0000-0000-0001-000e6154000a
SELECT is1.ser_id,is1.ser_oid id,substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),1,3) a,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),4,3)b,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),7,3)c,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),10,3)d,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),13,3)e,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),16,3)f,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),19,3)g,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),22,3)h,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),25,3)j,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),28,3)k,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),31,2)l,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),1,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),4,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),7,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),10,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),13,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),16,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),19,3)|| '/' ||
substr(lpad(trim(to_char(is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),22,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),25,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),28,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),31,2)|| '/' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),1,8 ) || '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),9,4) || '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),13,4)|| '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),17,4)|| '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),21,12) path
FROM itsm_servicecalls is1
WHERE is1.ser_id=111111
Вбиваем необходимый ID SC,получаем путь к файлу на ftp ресурсе
000/000/000/000/000/000/010/00b/5e9/6d8/b5/00000000-0000-0000-0001-000e6154000a
SELECT is1.ser_id,is1.ser_oid id,substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),1,3) a,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),4,3)b,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),7,3)c,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),10,3)d,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),13,3)e,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),16,3)f,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),19,3)g,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),22,3)h,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),25,3)j,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),28,3)k,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),31,2)l,
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),1,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),4,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),7,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),10,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),13,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),16,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),19,3)|| '/' ||
substr(lpad(trim(to_char(is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),22,3) || '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),25,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),28,3)|| '/' ||
substr(lpad(trim(to_char( is1.ser_oid, 'xxxxxxxxxxxxxxxx')),32,0),31,2)|| '/' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),1,8 ) || '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),9,4) || '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),13,4)|| '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),17,4)|| '-' ||
substr(lpad(trim(to_char(281536739147785 + 1, 'xxxxxxxxxxxxxxxx')),32,0),21,12) path
FROM itsm_servicecalls is1
WHERE is1.ser_id=111111
SD 4.5
App- SP39 win2008
BD- Linux oracle 12
App- SP39 win2008
BD- Linux oracle 12