Re: [Q] SQL calls from UNIX scripts?

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
___