How to quit sqlplus without any exit/quit
From: Sunny Singh <sunny313_at_hotmail.com>
Date: 1 Oct 2001 11:02:55 -0700
Message-ID: <f3f27ff5.0110011002.3e8b09a9_at_posting.google.com>
Date: 1 Oct 2001 11:02:55 -0700
Message-ID: <f3f27ff5.0110011002.3e8b09a9_at_posting.google.com>
SQLPLUS will keep on sitting on its SQL prompt if no exit/quit is
found in .sql:
$ 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:
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.
Please see below:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Any help is greatly appreciated.
Thanks. Received on Mon Oct 01 2001 - 20:02:55 CEST