Re: Optional Prompting for Parameters

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 19 Jun 2007 20:23:14 +0200
Message-ID: <f596uh$712$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Malcolm Dew-Jones wrote:

> Newer sqlplus has && to prompt just the first time. That way you can be
> prompted by name just the first time.

I doubt my recollection, but I could find the following in the SQL*Plus User's Guide and Reference, Version 3.1, part no. 5142-31-1192.

"You can avoid being re-prompted for the group and number columns by adding a second ampersand in front of each GROUP_COL and NUMBER_COL in STATS. SQL*Plus automatically DEFINEs any substitution variable preceded by two ampersands, but does not DEFINE those preceded with one ampersand" pg 3-19, "Manipulating Commands"

I believe this is the 1992 manual - "newer sqlplus"?? :)

PS - similar behavior for @@
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGeB8SLw8L4IAs830RArNtAJ47I1zG5+NUyANeqIwgwGo5QEQqUgCeMXPd NTDYXNTP7u3RZk4UU4mACkE=
=+QZU
-----END PGP SIGNATURE----- Received on Tue Jun 19 2007 - 13:23:14 CDT