PL/SQL: ORA-00933 命令未正确结束

Question

你好我正在尝试这个查询：

DECLARE
v_week NUMBER;

BEGIN
SELECT WEEK FROM WEEKDESTINATION INTO (v_week)
WHERE STARTDATE BETWEEN '02-JAN-2010'AND '09-JAN-2010';
END;

但它抛出以下错误： PL/SQL: ORA-00933: SQL 命令未正确结束

请帮助

Answer 1

应该是

SELECT WEEK INTO v_week FROM WEEKDESTINATION
where .......