Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PROCEDURE WITH CURSOR PROBLEM
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Guilherme wrote:
> sql := 'select * from table';
> IF p1 IS NOT NULL THEN
> sql := sql||'WHERE id = '||p1;
> END IF
> OPEN ret FOR sql;
Please don't.
It won't scale. It won't scale. It won't scale. It won't scale.
Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD8DBQFGdQN2Lw8L4IAs830RAnU0AJ9M2Xt7BALCF8wBVQm7G40l82wRvACfR1iJ
ALuW7n15irV8SUmoTZUT4D0=
=EfVC
-----END PGP SIGNATURE-----
Received on Sun Jun 17 2007 - 04:48:38 CDT