Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.
SELECT w.idwell, SUBSTR(b.afenumber, INSTR(b.afenumber,'10'),8) network, a.responsiblegrp2 z_eng, a.responsiblegrp1 z_sup, MAX(c.contractor ||' '||c.rigno ) KEEP (DENSE_RANK LAST ORDER BY c.syscreatedate) as RIG , a.syscreatedate, a.wvtyp JOB\ FROM wvwellheader w, wvjob a, wvjobafe b, wvjobrig c WHERE w.idwell = a.idwell AND a.idrec = b.idrecparent AND a.idrec = c.idrecparent AND b.afenumber IS NOT NULL AND c.dttmstart IS NOT NULL AND a.DTTMSTART > to_date( '01/MAY/2008', 'DD/MON/YYYY') AND w.idwell = 'B126D65D02754B0ABAA0394328315D64' GROUP BY a.wvtyp, w.idwell, b.afenumber, a.responsiblegrp2, a.responsiblegrp1, a.syscreatedate
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.