语法预言机错误

Question

SELECT LINE_NUMBER, time
FROM LINE
JOIN LINE_STOP  ON LINE.ID=LINE_STOP.LINE_ID
JOIN PASSAGE    ON LINE.STOP_ID = PASSAGE.LINE_STOP_ID
WHERE "time" =    (select count (*) as "time"
                        from passage 
                        where hours * 60 + minutes between 300 and 380);  

我有一个无效的标识符错误或 ora-00904。很确定是因为它不认识时间，但我不明白为什么。

Answer 1

时间在这里的

官方文档中被描述为一个单词..."对甲骨文具有特殊意义，但不是保留词，因此可以重新定义"。

如果必须使用列表中的任何单词，则必须将它们双引号，并使大小写与创建时使用的大小写保持一致。

SELECT LINE_NUMBER, "TIME"
FROM LINE
JOIN LINE_STOP  ON LINE.ID=LINE_STOP.LINE_ID
JOIN PASSAGE    ON LINE.STOP_ID = PASSAGE.LINE_STOP_ID
WHERE "TIME" =    (select count (*) as "TIME"
                        from passage 
                        where hours * 60 + minutes between 300 and 380);