Re: Selecting Duplicates ???

Nothing wrong in giving the PL/SQL block, as long as you don't have it saved, so loose the 'create or replace'. There's a special name for such a PL/SQL block (unbound?), and I've used them a lot. These are only executed in memory, removed when ending the session.

Richard Elliott wrote:
<snip>

> I like to solve these request with SQL selects
> if possible because I can give the SQL to the user and he can run it
> himself using ODBC if he needs to later.

--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV

Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046