Re: usernames

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Tue, 22 Feb 2005 19:41:18 +0100
Message-ID: <f3vm115dcqnbt7kq8ro07qc23s0u8k0jj0@4ax.com>

On Tue, 22 Feb 2005 14:25:28 +0100, Cris Carampa <cris119_at_operamail.com> wrote:

>lambu999_at_yahoo.com wrote:
>
>> Is there a different script for Windows. Thanks
>
>If Windows don't support the '<<' mechanism, you can create a SQL file
>using notepad, e.g.:
>
>--- q.sql ---
>set pages 100
>set pause off
>set feedback off
>set head off
>select username from all_users ;
>quit
>-------------
>
>and then the sqlplus (not sqlplusw!) command would be:
>
>sqlplus -s un/pw_at_db @q.sql > usernames.txt
>
>Kind regards,

Better make that 'set pages 0', or you'll get an empty line after each 100 lines.

Jaap. Received on Tue Feb 22 2005 - 12:41:18 CST