Re: SELECT COUNT in dynamic SQL
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/23
Message-ID: <5781sj$gg8_at_newton.pacific.net.sg>#1/1
Date: 1996/11/23
Message-ID: <5781sj$gg8_at_newton.pacific.net.sg>#1/1
gwen_at_infomatch.com (Gwendolyne Chua) wrote:
>I'm wondering if there is a way to get the result of
>a SELECT COUNT in dynamic SQL. With the SQLDA structure,
>you can do a regular SELECT (ie. Method 4 of dynamic
>SQL) with fields and stuff but how does one handle
>SELECT COUNT, AVG, and such functions?
>
>Thanks,
>Gwen.
HI there,
If you are using Oracle 7.2 and later, you can issue DBMS_SQL to execute dynamic SQL.
Regards
N.Prabhakar Received on Sat Nov 23 1996 - 00:00:00 CET