Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: usernames

Re: usernames

From: Cris Carampa <cris119_at_operamail.com>
Date: Tue, 22 Feb 2005 09:44:13 +0100
Message-ID: <421af0f2$0$6311$5fc30a8@news.tiscali.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US