RE: Unix bourne shell HELP

To run sqlplus within a shell 'enclose' the sql commands as follows (by << EOF to start, and by EOF to end, starting at col 1 ). You can use any matching chars for 'EOF'...

#!/bin/sh
sqlplus /nolog << EOF
connect internal
select * from cat;
exit
EOF

• Kirti

> -----Original Message-----
> From: Mr. Majestic [SMTP:rc_at_neomenia.com]
> Sent: Monday, June 19, 2000 1:45 PM
> To: ORACLE-L_at_fatcity.com; 'lazydba'
> Subject: Unix bourne shell HELP
>
> I'm executing this bourn shell script below. When I call the file to
> execute, I'm only getting logged on to sql plus with sqlplus /nolog.
>
> How can I get the other statements to execute??
>
> thanks
>
>
> #!/bin/sh
>
> sqlplus /nolog
>
> connect internal
>
> select * from cat;
Received on Mon Jun 19 2000 - 13:58:00 CDT