Hello,
Napisalem zapytanie sql i dziala calkiem niezle lecz gdy musialem dodac dodatkowe nazwy parametrow( drying%Total, drying%1, drying%2) powstal nastepujacy problem.
Problemem jest uzycie wildcarda w nazwie parametrow (% w Oracle). Zdaje sobie sprawe ze moglbym uzyc komendy ESCAPE lecz nie moge wpasc na pomysl jak dokladnie. Nie jestem pewien czy mozna uzyc ESCAPE z MAX i czy nie powinna byc ona uzyta z LIKE komenda.Czy mogliby Panstwo mi pomoc?
Z gory dziekuje za wszystkie odpowiedzi.
Pozdrawiam
SELECT c.numlotpharma AS lotnum , c.numof ,
MAX(DECODE(RTRIM(a.parametercode),’DRYING’,numvalue,0)) AS dryingdata,
MAX(DECODE(RTRIM(a.parametercode),’DRYING%Total’,numvalue,0)) AS dryingpercentageTotal,
MAX(DECODE(RTRIM(a.parametercode),’DRYING%1′,numvalue,0)) AS dryingpercentage1,
MAX(DECODE(RTRIM(a.parametercode),’DRYING%2′,numvalue,0)) AS dryingpercentage2,
FROM prodaccount.manufacturingdata a
INNER JOIN
(SELECT MAX(inputindex) AS inputindex,
parametercode ,
mancode
FROM prodaccount.manufacturingdata
WHERE parametercode IN (’DRYING’)
GROUP BY parametercode, mancode) b
ON a.inputindex = b.inputindex
AND a.parametercode = b.parametercode
AND a.mancode = b.mancode
INNER JOIN (SELECT Numlotpharma, numof , codeproduit
FROM prodaccount.batchlotdetails d
WHERE d.codeproduit = (’Tablets’)) c
ON a.mancode = c.numof
GROUP BY c.numlotpharma, c.numof
ORDER BY lotnum