Re: Inputting into PL/SQL From SQL*Plus
From: Mike Oswald <moswald_at_netserv.unmc.edu>
Date: 9 May 1994 15:05:08 -0500
Message-ID: <2qm51k$3q0_at_netserv.unmc.edu>
Date: 9 May 1994 15:05:08 -0500
Message-ID: <2qm51k$3q0_at_netserv.unmc.edu>
Mike Oswald (moswald_at_netserv.unmc.edu) wrote:
: Has anyone tried to used SQL*Plus substitution variables in a PL/SQL
: block? What I'm trying to do is pass a &&1 or &1 to the PL/SQL block
: select statment.
: If you have any ideas...let me know.
: Thanks.
: -Mike
To explain further...I have records in the database that have duplicates... Until the new database is up and running I have to find a way to count the number of MAU's and MAU Ports available.
Example: Token Ring #240 has the following MAU & ports.
01/01 Each Mau can have 8 ports...but the database has
01/02 allowed the data entry person to do what they want.
01/03
...etc...
02/01
02/02
...etc...
What's happening...is that there are records like 01/01, 01/01, 01/01, etc. This is okay...SORT OF...
I need to SELECT <blah> MINUS dups. Any ideas?
-Mike Received on Mon May 09 1994 - 22:05:08 CEST