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: window solution :-)

Re: window solution :-)

From: jazzz_ <jazzz__at_poczta.onet.pl>
Date: Wed, 23 Feb 2005 07:42:17 +0100
Message-ID: <cvhako$5gr$1@atlantis.news.tpi.pl>


:-)
does anyone know how to get lower case usernames using sqlplus? jazzz_
Użytkownik "jazzz_" <jazzz__at_poczta.onet.pl> napisał w wiadomości news:cvfcjf$slk$1_at_nemesis.news.tpi.pl...
> OK, thanks for your help
> I found solution.
>
> here is Windows version:
>
> 1. Make batch file 1.sql which include:
>
> sqlplus @c:\username.sql
>
> 2. Make file username.sql and inside put:
>
> us/pass_at_db
> spool c:\parm1.txt
> set pages 1000
> set pause off
> set feedback off
> set head off
> begin
> select username from all_users where username<>'DEMO' AND username<>'SYS'
> AND username<>'SYSTEM' AND username<>'SCOTT' AND username<>'DBSNMP';
> exit;
>
> 3. run 1.sql
>
>
>
Received on Wed Feb 23 2005 - 00:42:17 CST

Original text of this message

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