SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select query having count function is returning null

BS2012May 31 2013 — edited Jun 3 2013

Hi Everyone,
Please see the query and help me to get this solved.

DB version

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
"CORE	10.2.0.1.0	Production"
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

QUERY

SELECT COUNT(*) as V_COUNT
      FROM LAB_ORDER_TMPLT_TEST
      WHERE TEST_ID IN
      (SELECT WEST_TEST_ID
              FROM TEST_CODE_CONVERSION TCC
              WHERE TCC.EAST_TEST_ID = 2769)
      GROUP BY LAB_ORDER_TMPLT_ID
      HAVING COUNT(*) > 1;
It's returning null. Is there any way I can get the value as zero instead of null? Please help.

Regards,
BS2012.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2013

Added on May 31 2013

8 comments

4,224 views