Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

missing keyword - ORA00905

user2342515Dec 9 2011 — edited Dec 16 2011
I got missing keyword for this simple SQL as following:

select max(proc_seq)
from STAT_TABLE
where case_nmbr = 'D215238' and
pers_nmbr = '001' and
proc_seq <= '01 Dec, 2008' and
payee = 'P' and
date_id = 46752;

Any suggestion?

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2012
Added on Dec 9 2011
14 comments
5,311 views