Select NVL(count(*),0) from TABLA

Hemos desarrollado un Report en el que utilizamos la expresión:
   Select NVL(count(*),0) from TABLA

Sabemos que esta expresión es correcta pero nos sale el error ORA-00936: falta una expresión.

El Report está desarrollado en la version 6.0 de Developer y la BBDD es la 8.0.5

¿Nos podías ayudar a solucionarlo?

Gracias.
juanhoAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
didn't understand what you wrote,
but you do not need an NVL if you want only to count,
even is the table empty you will get a 0 as result

also use
Select count(*) from TABLA

meikl ;-)

0
 
soraCommented:
count(*) will never be NULL. So, no need to use NVL


sora
0
 
soraCommented:
kretzschmar - sorry I missed reading your comment in which you already said the same thing

can we have a translator, please :-)


sora
0
 
kretzschmarCommented:
translated by babelfish:
We have developed a Report in which we used the expression: Select NVL(count(*), 0) from TABLE We know that this expression is correct but it leaves the Ora-00936 error to us: it lacks an expression. The Report is developed in version 6.0 of Developer and the BBDD is the 8.0.5 You could help to solve it us? Thanks.
0
 
kretzschmarCommented:
oops, not seen the grading, before

glad to helped you

meikl ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.