ORA-00909: invalid number of arguments (sql-oracle) | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

ORA-00909: invalid number of arguments (sql-oracle)

create view sq as select avg(qula,shualeduri,finaluri,saboloo) as sb from sagani where sagnis_id=9;

31st May 2019, 1:06 PM
kokito
1 Answer
+ 2
The AVG() function can have only a single argument, as it calculates average of one field across rows, and not across columns. If you want the average of 4 different fields then you can try like this: (qula + shualeduri + finaluri + saboloo) / 4 as sb
31st May 2019, 8:09 PM
Tibor Santa
Tibor Santa - avatar