Re: SQL request

hello,
you should write a script
script.sql
set term off
set lines nnn
set pages 0 (nnnn)
set ....
spool file.txt
select ......
/
spool off
exit

I use AIX operating system and in CRONTAB list i would put command sqlplus -s UN/PW Žscript.sql

Minh-Duc PHAM wrote:

> Hello,
>
> I wish to retrieve information from an Oracle (release 7 or 8) database
> (used by Plantspace) by sending a SQL request and save the result in a
> delimited file text for further use.
>
> What is the best way to proceed ?
> - send directly a request to a SQL server ; but how ?
> - buy a third-party tool
> - other way
>
> This task should be done in the background as soon as possible.
>
> Many thanks in advance.
>
> Minh-Duc
>
> PS : Please remove the minus from my user name if you wish to answer
> also directly to me.
  Received on Fri Jan 05 2001 - 16:15:01 CET