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: jazzz_ <jazzz__at_poczta.onet.pl>
Date: Tue, 22 Feb 2005 10:46:21 +0100
Message-ID: <cvev2l$344$1@atlantis.news.tpi.pl>


I can connect db using sqlplus -s un/pw_at_db , but i don't know how to make sqlplus to get usernames and write them to txt file. What does it mean: <<__END__ ???

regards,
jazzz_

Uzytkownik "Cris Carampa" <cris119_at_operamail.com> napisal w wiadomosci news:421af0f2$0$6311$5fc30a8_at_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 - 03:46:21 CST

Original text of this message

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