Home -> Usenet -> comp.databases.oracle -> select connect in a PL/SQL routine

select connect in a PL/SQL routine

From: Fleury Marcel <marcel.fleury_at_bluewin.ch>
Date: 5 Jun 2002 05:58:54 -0700
Message-ID: <f18358b2.0206050458.1cab8c2c_at_posting.google.com> 






Hello,


From sqplus I use the following command to display all accounts that
use the same string for the username and password :



SQL> select 'connect '||username||'/'||username from all_users;



'CONNECT'||USERNAME||'/'||USERNAME





connect SYS/SYS



But I would like to use this command into a PL/SQL routine.
How can I do it ?



Tnak you
Received on Wed Jun 05 2002 - 14:58:54 CEST












Original text of this message