select substr('RAZ_DVA_TRI_CTYRI_PET_SEST_SEDM_OSM',1,instr('RAZ_DVA_TRI_CTYRI_PET_SEST_SEDM_OSM','_',1,4)-1) AS orez from dual
Odkazy
Rubriky
select substr('RAZ_DVA_TRI_CTYRI_PET_SEST_SEDM_OSM',1,instr('RAZ_DVA_TRI_CTYRI_PET_SEST_SEDM_OSM','_',1,4)-1) AS orez from dual