dynamic sql with duplicated placeholders

From: Robert Yeh <robert.yeh_at_qwest.com>
Date: Thu, 28 Jun 2001 17:48:33 -0400
Message-ID: <9hg8d5$do7$1@bob.news.rcn.net>

I know I don't have to repeat the variable name for same placeholder if I put the sql string in a PL/SQL block.

I copied this from Oracle doc.
For example:
DECLARE
   a NUMBER := 4;
   b NUMBER := 7;
BEGIN
   plsql_block := 'BEGIN insert into table values (:x, :x, :y, :x); END;'    EXECUTE IMMEDIATE plsql_block USING a, b;    ...
END; Is it possible to do the same thing in OPEN cursor FOR ...? declare

DECLARE
   a NUMBER := 4;
   b NUMBER := 7;
BEGIN
   OPEN csr FOR 'select :x, :x, :y, :x from dual' USING a, b; ...
END; How do I put it in a PL/SQL block? Received on Thu Jun 28 2001 - 16:48:33 CDT