Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: usernames
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