mardi 18 décembre 2018

How to pass a count as IF condition on ORACLE

i want to do a thing like this pseudocode on oracle:

select count(d.number_people) as counted_people
from dual d
if counted_people = 1 then
dbms_output.put_line('Have just one people on this column.'
end if;

This syntax is wrong, I know, how do I do it the right way?

Aucun commentaire:

Enregistrer un commentaire