Re: How to query Oracle from UNIX (AIX)?

In article <32E52993.55FC_at_amdahl.com> Richard <Richard_Fisher_at_amdahl.com> writes:
>Per Gunnare wrote:
>>
>> I want to extract data from Oracle Server 7 into textfiles from
>> a UNIX (AIX) machine. What do I need to be able to do this?
>>
>> I prefer not to spend a lot of money so I would like to have
>> somthing that let me submit an SQL query and get back the
>> result which could be redirected to a text file.
>>
>> A cheap graphical query tool could be one alternative. Other ones
>> could be Perl, Awk or Python.
>>
>> ===========================================================================
>> Per Gunnare Email: pg_at_kcs.se
>> Manager, Customer Support Tel: +81-6-399-7091
>> Kockums Computer Systems K.K. Fax: +81-6-399-7092
>> Sumitomo Seimei Shin-Osaka Kita Bldg. 11F Web: http://www.kcs.se/
>> 4-1-14 Miyahara, Yodogawa-ku
>> Osaka 532, JAPAN
>> ===========================================================================
>
>Simply use the spool command from sqlplus and you can send the output
>straight to a file. If you set the pagelength to some enormous number
>and the headings off you will efectively get a flat file out of it.
>If you want more detail, let me know.

Or, just SET PAGESIZE 0 in sqlplus, then spool your_filename.

>Regards....Richard
>--
> \|||/
> (. .)
>ooO-(_)-Ooo--------------------------------------------
> Name: Richard Fisher | Specialist MSE
> E-mail Address | Richard_Fisher_at_amdahl.com
> Date: _at_date@ | Any opinions expressed
> Time: _at_time@ | above are mine and do not
> necessarily represent the opinions or policies of Amdahl Corporation
>===========================================================
>My opinions may have changed, but not the fact that I'm right!
>______________________________________________________________

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O