Language: PL/SQL Highlight Mode: PLSQL Last Modified: February 27th, 2009
SET termout off head off
col nl newline
SELECT'alter user &&1 identified by &&1;' nl,'connect &&1/&&1' nl,'alter user &&1 identified by values '''||u.password||''';' nl
FROM sys.dba_users u
WHERE u.username =UPPER('&&1')AND u.username <>USER/
REM DELETE the file.USE"rm"ON Unix,"del"FOR Win/Dos
! rm su.tmp
! del su.tmp
SET termout ONSELECT'Connected as '||USER||' on '||global_name||'.'FROM global_name;SET termout ON head ON
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.