Re: How to quit sqlplus without any exit/quit

sunny313_at_hotmail.com (Sunny Singh) wrote in message news:<f3f27ff5.0110011002.3e8b09a9_at_posting.google.com>...
> SQLPLUS will keep on sitting on its SQL prompt if no exit/quit is
> found in .sql:
> Please see below:
>
> $ sqlplus sa/sa_at_lyweb @cr_tab.sql
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 28 14:19:41 2001
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
>
> Table created.
>
> SQL> (control stays here)...
>
> As you see, it did not exit. My question is How can we signal SQLPLUS
> to exit without really saying EXIT in .sql file. SQLPLUS did not do an
> implicit exit, as you can see.
>
> Any help is greatly appreciated.
>
> Thanks.

Use this call in a .cmd or a .bat file and it definitely will exit! Otherwise just try not to forget typing those four letters.

Hth,

Sybrand Bakker, Senior Oracle DBA

Sybrand Received on Tue Oct 02 2001 - 10:09:23 CEST