AnyTime的发布日期

Question

我正在尝试创建查询，它将返回所有项目，这是取消，但这是随时释放。

select substr(tarifa,1,2) as tarifa, count(*) as komada
from pol p, uvod u, doppov d
where (datum_dop >= '1-jan-12')  AND (datum_dop <= '31-dec-12') 
and   p.orgjed = u.sorgz  (+)
and   p.polica=d.polica and d.pov_dopl='P'
--and DATUM_PREKIDA is not null
and d.status='F'
and cisti_ao(p.polica)!=0
group by substr(tarifa,1,2);

我的表中有release(izdavanje)列，当我在数据库浏览器中尝试这样的操作时

select substr(tarifa,1,2) as tarifa, count(*) as komada
from pol p, uvod u, doppov d
where (datum_dop >= '1-jan-12')  AND (datum_dop <= '31-dec-12')
and   (izdavanje >= '1-jun-12') AND (izdavanje  <= '28-jun-12')
and   p.orgjed = u.sorgz  (+)
and   p.polica=d.polica and d.pov_dopl='P'
--and DATUM_PREKIDA is not null
and d.status='F'
and cisti_ao(p.polica)!=0
group by substr(tarifa,1,2);

但我得到错误ORA-00911无效字符。谁能告诉我我哪里弄错了？

Answer 1

您应该认真地切换到使用现代连接语法。此外，您还应该使用有效的Oracle日期文本：

SELECT
    SUBSTR(tarifa, 1, 2) AS tarifa,
    COUNT(*) AS komada
FROM pol p
LEFT JOIN uvod u
    ON p.orgjed = u.sorgz
INNER JOIN doppov d
    p.polica = d.polica
WHERE
    datum_dop BETWEEN DATE '2012-01-01' AND DATE '2012-12-31' AND
    izdavanje BETWEEN DATE '2012-06-01' AND DATE '2012-06-28' AND
    d.pov_dopl = 'P' AND
    d.status = 'F' AND
    cisti_ao(p.polica) != 0
GROUP BY
    SUBSTR(tarifa, 1, 2);