Avatar of maximus1974
maximus1974

asked on 

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/SQLSQL* oracle syntax

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)
Avatar of Molnár István
Molnár István
Flag of Romania image

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
Avatar of Bill Prew
Bill Prew

Blurred text
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
Avatar of maximus1974
maximus1974

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
Avatar of Bill Prew
Bill Prew

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
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Is it Oracle or MS SQL Server? If it is MS SQL Server, a CASE statement requires END (which you don't have)
>>I know oracle uses PL\SQL

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo