Re: [Q] SQL calls from UNIX scripts?

In article <2t3rn4$2ms_at_netserver.univ-lille1.fr> noel_at_omega.univ-lille1.fr (Yves Noel) writes:
>
>In article <Cr1n8x.1Ips_at_ief.itg.ti.com>, rlscott_at_lobby.ti.com (Raymond Scott) writes:
>|>We have both Sybase and Oracle installed on an
>|>HP 9000 running HP-UX. I would like to be able
>|>to execute SQL from a UNIX script. The goal is
>|>to be able to create 'quicky' transactions to
>|>perform frequently done SQL etc.
>|>
>|>Is this possible? How do I do this?
>|>TIA
>|
>Very easy to do, below the type of script I use every days. In a file you put :
>
>cat > temp.sql << EOF
> .
> .
> . you SQL, SQL*Plus, PL/SQL commands
> .
> .
>/ <-- to execute
>exit <-- to go out
>EOF <-- the end of the script
>sqlplus -s / _at_temp.sql <-- execution under SQL*Plus
>rm -f temp.sql <-- if you want to remove temp.sql
>
>Don't forget to put execution privilege on the file that contains these lines.
>Hope this help.
>--
>Yves NOEL ______________________________________________ C.I.T.I. (batiment M4)
>Database Administrator ________________ Universite des Sciences et Technologies
>Email: Yves.Noel_at_univ-lille1.fr ________ 59655 Villeneuve d'Ascq Cedex - FRANCE
>Voice: (33) 20.33.70.74 _________________________________ Fax: (33) 20.43.66.25
>
>I use ORACLE v6.0.36 on DEC RISC ULTRIX v4.3
>___
Received on Wed Jun 08 1994 - 14:33:22 CEST