Oracle Database Discussions

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!

MS Access Query to Oracle

954337Aug 7 2012 — edited Aug 10 2012

Hi Gurus

I am trying to convert a MS Access query to Oracle query, Having some trouble Need some help Please.

This is the MS Access Query:

Sum(IIf(LOAD1!ARRIVDATE<+Date()+7,LOADLINE1!QTY,0)/ITEM1!UOM) AS Loadtbl

What would be the Oracle Query???

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2012

Added on Aug 7 2012

#database-and-application-migrations, #migration, #sql, #sqldeveloper

8 comments

3,371 views