Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: usernames
jazzz_ wrote:
> how to get usernames from oracle database using shell script (from cmd line)
#!/bin/bash
sqlplus -s un/pw_at_db << __END__
set pages 100
set pause off
set feedback off
set head off
select username from all_users ;
quit
__END__
Kind regards,
-- Cris Carampa (cris119_at_operamail.com) "Torna il re. Prosegue l'attesa per fante e cavallo." (da "Umanità Nova" n. 14 del 21 aprile 2002)Received on Tue Feb 22 2005 - 02:44:13 CST