views:

25

answers:

1

hello Im trying this query:

DECLARE
v_week NUMBER;

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

but it throws the following error: PL/SQL: ORA-00933: SQL command not properly ended

please help

+5  A: 

Should be

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