Formatting error
Posted: Wed 03 Dec 2014 13:14
The statement below is not recognized as valid, it stops before the '.EXTRACT'in the statement claiming that additional ')' have to be supplied. It runs ok however.
Code: Select all
SELECT NVL(rtrim (xmlagg (XMLELEMENT (e, upper(lp.licenseplate)
|| '; ')).EXTRACT ('//text()'), '; ') ,'') AS VALUE
FROM Permit p
INNER JOIN LicensePlate lp
ON p.PermitID = lp.ParkPermitID
WHERE lp.validfrom_dt <= p.validuntil_dt
AND (lp.validuntil_dt IS NULL
OR lp.validuntil_dt >= CURRENT_DATE)
AND PermitID =:permitID