Re: syntax error

Remove "-" between "COUNT(*) - COUNT"

Akhilesh

Karsten Schenk wrote:
> I 'm a beginner and I have following question:
> Something seems to be wrong with the syntax of these lines.
> It must be something tiny.
> Can anyone help me?
>
> EXECUTE IMMEDIATE 'SELECT COUNT(*) - COUNT ('|| c || ') AS nulls,
> COUNT(DISTINCT ' || c || ') AS different , COUNT ('||c||') AS total'
> FROM ' || t INTO nulls, different, total;
> EXECUTE IMMEDIATE 'INSERT INTO ' || dest || ' (id, nulls, different,
> total) VALUES ( :1, :2, :3, :4)' USING (id, nulls, different, total);
>
> Thanks in advance
>
> Karsten
Received on Fri Jun 23 2006 - 02:17:05 CDT