SQL Error ORA-00905: missing keyword

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Error ORA-00905: missing keyword

Author

Topic

ending123
Starting Member

1 Post

Posted - 2013-09-22 : 18:29:53

I am new to SQL Programming, and any help would be appreciated on this error. Error is in front of the GROUP BY clause

Explain Plan Error:

ORA-00905: missing keyword (DBD ERROR: error possibly near <*> indicator at char 672

SELECT
trunc(ducsi.ship_day,'D')+6 AS Week
,CASE WHEN ducsi.is_retail_merchant = 'Y' then 'Retail'
WHEN ducsi.is_retail_merchant = 'N' then '3P'
ELSE 'Not Available'
END AS channel
,SUM(ducsi.shipped_units) AS Shipped_Units
,SUM(ducsi.shipped_amt) AS Shipped_Amount

FROM
d_unified_cust_shipment_items ducsi

WHERE

ducsi.region_id = 1
AND ducsi.marketplace_id = 1

AND ducsi.gl_product_group = 60

AND ducsi.ship_day BETWEEN(' (''2013/04/01'',''YYYYMMDD'')
AND (''2013/04/30'',''YYYY/MM/DD'')')

<*>GROUP BY
trunc(ducsi.ship_day,'D')+6
,CASE WHEN ducsi.is_retail_merchant = 'Y' then 'Retail'
WHEN ducsi.is_retail_merchant = 'N' then '3P'
ELSE 'Not Available'
END
')

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-22 : 22:24:47

This forum is for Microsoft SQL Server. So there would be few, if any, who are experts on Oracle. You would get faster and better responses at an Oracle forum or a generalized database forum such as dbforums.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources