asked on 10/29/2018

Need help determining cause of "FROM keyword not found where expected"

Need help determining why I keep getting "FROM keyword not found where expected" when i run the following in Oracle SQL Developer. Runs fine in Microsoft SQL Server. I know oracle uses PL\SQL but cannot find the culprit.

SELECT        BA_VIEW_SHIPPING_ORDERS.SM_NUMBER, BA_VIEW_SHIPPING_ORDERS.STATUS AS SM_STATUS, BA_VIEW_SHIPPING_ORDERS.ORDER_TYPE, 
                         BA_VIEW_SHIPPING_ORDERS.ORDER_NUMBER, DEPARTMENT.DEPT_NAME, BA_VIEW_SHIPPING_ORDERS.PN, 
                         BA_VIEW_SHIPPING_ORDERS.DESCRIPTION, BA_VIEW_SHIPPING_ORDERS.SHIP_NAME AS CUSTOMER_NAME, 
                         BA_VIEW_SHIPPING_ORDERS.SHIP_VIA_CODE, (CASE WHEN BA_VIEW_WO_SUMMARY.CONTRACT_TAT IS NULL 
                         THEN 21 ELSE BA_VIEW_WO_SUMMARY.CONTRACT_TAT END-BA_VIEW_WO_SUMMARY.NET_TAT) WO_DAYS_LEFT, (SELECT BA_VIEW_SHIPPING_ORDERS.DUE_DATE-SYSDATE) SO_DAYS_LEFT, 
                         (SELECT sysdate-BA_VIEW_SHIPPING_ORDERS.ENTRY_DATE WHERE ORDER_TYPE = 'RO') RO_DAYS_LEFT, (SELECT SYSDATE-BA_VIEW_SHIPPING_ORDERS.ENTRY_DATE WHERE ORDER_TYPE = 'WHS') WHS_DAYS_LEFT 
FROM            BA_VIEW_SHIPPING_ORDERS LEFT OUTER JOIN
                         BA_VIEW_WO_SUMMARY ON BA_VIEW_SHIPPING_ORDERS.ORDER_NUMBER = BA_VIEW_WO_SUMMARY.WO_NUMBER LEFT OUTER JOIN
                         DEPARTMENT ON BA_VIEW_SHIPPING_ORDERS.DPT_AUTO_KEY = DEPARTMENT.DPT_AUTO_KEY
WHERE        BA_VIEW_SHIPPING_ORDERS.SM_NUMBER LIKE 'SHA%' AND (BA_VIEW_SHIPPING_ORDERS.STATUS NOT IN ('SHIPPED', 'CANCELLED')

Open in new window

Microsoft SQL Server * PL/SQL SQL * oracle syntax

Last Comment

slightwv (䄆 Netminder)

10/29/2018

Molnár István

10/29/2018

try like this, i think you are missing a ")":
WHERE BA_VIEW_SHIPPING_ORDERS.SM_NUMBER LIKE 'SHA%' AND (BA_VIEW_SHIPPING_ORDERS.STATUS NOT IN ('SHIPPED', 'CANCELLED'))

or you can try like this
WHERE (BA_VIEW_SHIPPING_ORDERS.SM_NUMBER LIKE 'SHA%') AND (BA_VIEW_SHIPPING_ORDERS.STATUS NOT IN ('SHIPPED', 'CANCELLED'))

hope it helps

ASKER CERTIFIED SOLUTION

Bill Prew

10/29/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

maximus1974

10/29/2018

ASKER

Thank you Molnar but i keep getting the same error using your suggestions. I have attached a screenshot of the error. Seems it doesn't like line 5, the case.
Capture.JPG

Bill Prew

10/29/2018

Oracle is different than SQL Server, you can't have a SELECT without a FROM, you have to use DUAL in that case. But you don't need / want a SELECT in those fields anyway, you can just reference the column names to build the formula for the calculated fields. See my example...

»bp

Éric Moreau

10/29/2018

Is it Oracle or MS SQL Server? If it is MS SQL Server, a CASE statement requires END (which you don't have)

slightwv (䄆 Netminder)

10/29/2018

>>I know oracle uses PL\SQL

FYI: PL/SQL is Oracle's Procedural Language for stored procedures and functions. Straight SQL is simply SQL.

Need help determining cause of &quot;FROM keyword not found where expected&quot;

Need help determining cause of "FROM keyword not found where expected"