none
Missing Expression Error RRS feed

  • Question

  • I am getting this error "ORA-00905: missing keyword
    00905. 00000 -  "missing keyword"
    *Cause:    
    *Action:
    Error at Line: 20 Column: 76"

    While trying to run the following query.

    WITH t as (
           SELECT tot.student_id,
                  tot.first_name,
                  tot.last_name,
                  tot.track_date,
           MAX(track_date) over (partition by tot.student_id) as max_track_date
       from student tot
       inner join student_backup toov
         on tot.student_id = toov.student_id
         AND CASE WHEN tot.track_date IS NULL THEN SYSDATE ELSE tot.track_date between toov.start_dt AND toov.start_dt + toov.duration/60/40 END 
       where toov.course_id=163121
    )
    SELECT * FROM t;

    Please help me regarding this. Thanks in advance

    • Moved by Bill_Stewart Friday, July 7, 2017 4:28 PM Off-topic/unanswerable drive-by question
    Thursday, May 4, 2017 5:54 PM

All replies