Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> window solution :-)
OK, thanks for your help
I found solution.
here is Windows version:
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 Tue Feb 22 2005 - 07:33:32 CST