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!

ORA-00923 FROM keyword expected

RengudiNov 14 2008 — edited Nov 15 2008

Hi

While executing the below query i got ORA-00923 error

SELECT DOCTYPEID,to_char(B.DOCTIMESTAMP,'YYYY-MON-DD') DOCDATE,to_char(B.DOCTIMESTAMP,'HH24:MI') HOURS,count(*),AVG(dbms_lob.getlength(TYPEDATA)),T.TYPENAME FROM BIZDOC B, BIZDOCTYPEDEF T WHERE B.DOCTYPEID=T.TYPEID AND to_char(B.DOCTIMESTAMP,'YYYY-MON%') like ('2008-SEP%')
group by DOCTYPEID,to_char(B.DOCTIMESTAMP,'YYYY-MON-DD'),to_char(B.DOCTIMESTAMP,'HH24:MI'),T.TYPENAME order by HOURS;

Please help.

Thanks
Raj

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2008

Added on Nov 14 2008

19 comments

921 views