Creating View in Oracle SQL

Question

I am trying to create a view on my database but I keep getting ORA-00934:

group function is not allowed here error

Any help?

Here is my code:

CREATE VIEW MY_PRODUCTS_CE2_SELECT_MBILI
AS SELECT PROD_NAME,PROD_CATEGORY,PROD_SUBCATEGORY 
FROM MY_PRODUCTS_CE2
WHERE PROD_LIST_PRICE > AVG(PROD_LIST_PRICE)    
WITH CHECK OPTION CONSTRAINT MyProductsCE2SelectMbili_Cnst;

Iswanto San · Accepted Answer · 2013-02-27 04:06:02Z

5

You can't put aggregate function in WHERE clause.

Change your query to this:

CREATE VIEW MY_PRODUCTS_CE2_SELECT_MBILI 
AS SELECT PROD_NAME,PROD_CATEGORY,PROD_SUBCATEGORY 
FROM MY_PRODUCTS_CE2 WHERE PROD_LIST_PRICE > (SELECT AVG(PROD_LIST_PRICE) FROM MY_PRODUCTS_CE2)
WITH CHECK OPTION CONSTRAINT MyProductsCE2SelectMbili_Cnst;

More : Oracle/PLSQL: ORA-00934 Error

answered Feb 27, 2013 at 4:06

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tgbrunet Over a year ago

Sorry for the really late response but this worked. Thank you.

Collectives™ on Stack Overflow

Creating View in Oracle SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related