有没有办法用甲骨文写不(a和B)?
WITH intermediate AS (
SELECT
TO_DATE(start_date, 'YYYY-MM-DD') start_date,
TO_DATE(end_date, 'YYYY-MM-DD') end_date,
TO_DATE(start_date, 'YYYY-MM-DD') - LAG(TO_DATE(start_date, 'YYYY-MM-DD')) OVER (ORDER BY Start_Date) SLAG,
LEAD(TO_DATE(end_date, 'YYYY-MM-DD'))OVER (ORDER BY Start_Date) - TO_DATE(end_date, 'YYYY-MM-DD') ELEAD
FROM
Projects
ORDER BY
start_date
)
SELECT *
FROM
intermediate i
WHERE
NOT (i.SLAG == 1 AND i.ELEAD == 1)
;
非(i.laff==1和i.ELEAD==1)
*
第16行出错:
ORA-00936:表达缺失