Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem coming out sqlplus from korn shell script

Re: Problem coming out sqlplus from korn shell script

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 26 Aug 1998 02:27:00 GMT
Message-ID: <35e71d6e.3806636@netnews.worldnet.att.net>


On Mon, 24 Aug 1998 17:47:47 -0500, Ramey Muforo <muforo_at_gte.net> wrote:

>When I run an oracle script embeded in korn shell, it executes the
>sqlplus commands, but it finishes, it waits at the sqlplus prompt. What
>do I have to do for it to totally get out of sqplus and return to the
>command line.

use the SQL*Plus EXIT command. Write your script like this:

SELECT * FROM whatever;
INSERT ...
DELETE... EXIT regards,

Jonathan Gennick Received on Tue Aug 25 1998 - 21:27:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US