Oracle problem.
lazarus / 16-Databases

----------------------------------------------------------------------
BSaidus · 2018-03-01 09:38

Hello;
I have this message while trying to open a TZQuery :
 Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
OracleConnection1 : ORA-24347: d?tection d'une colonne NULL dans une
fonction AGGREGATE Any help to bypasse this !!?

----------------------------------------------------------------------
valdir.marcos · 2018-03-01 11:52

ORA-24347: Warning of a NULL column in an aggregate function

Use the function NVL:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions105.ht
m
https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_204
8.htm#OLADM624

For example:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
AVG(NVL(Salary,0)) FROM Employee;

----------------------------------------------------------------------
BSaidus · 2018-03-01 14:48

Quote from: valdir.marcos on March 01, 2018, 12:52:44 pmORA-24347:
Warning of a NULL column in an aggregate function

Use the function NVL:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions105.ht
m
https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_204
8.htm#OLADM624

For example:
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
AVG(NVL(Salary,0)) FROM Employee;

Thnks