Re: Ctrl C in SQLPlus exits Windows

Actually, he should switch to SQL*Developer. It doesn't get killed by Ctrl-C. A long time ago, in a galaxy far, far away, there was an OS which had Ctrl-Y in addition to Ctrl-C. I still map Ctrl-Y to SIGQUIT, in order to be able to kill the process if I need. The relevant .bashrc snippet looks like this:

stty erase '^?' intr '^C' susp '^Z' quit '^Y' kill '^X' echoe unset LS_COLORS
TERM=xterm
tset -r

However, I believe that the Windows version of sqlplus  is not bad, it was just programmed that way. The Linux version does not terminate the program:

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Mar 10 19:35:57 2019 Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Last Successful login time: Fri Mar 08 2019 14:27:56 -04:00

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0

SQL> select * from emp;

      EMPNO ENAME      JOB           MGR HIREDATE SAL         COMM ---------- ---------- --------- ---------- -------- ---------- ----------      DEPTNO

       7499 ALLEN      SALESMAN          7698 19810220      1600    
       300
     30

       7521 WARD       SALESMAN          7698 19810222      1250    

       7900 JAMES      CLERK          7698 19811203    950      30

       7902 FORD       ANALYST          7566 19811203   3000      20

       7934 MILLER     CLERK          7782 19820123 1300      10

14 rows selected.

Elapsed: 00:00:00.01
SQL>

SQL>
SQL>
SQL>

However, Jeff Smith has spoiled me rotten. Since approximately a year ago, I am only using this:

mgogala_at_umajor:~$ sql scott/tiger_at_ora18c/orclpdb.home.com

SQLcl: Release 18.4 Production on Sun Mar 10 19:38:38 2019

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0

On 3/10/19 11:41 AM, Mark W. Farnham wrote:
>
> ah. using command prompt sqlplus versus the “gui” sqlplus may be
> effective. Ram, can you switch to the command line version of sqlplus?
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Chris Taylor
> *Sent:* Sunday, March 10, 2019 10:39 AM
> *To:* lambu999_at_gmail.com
> *Cc:* ORACLE-L
> *Subject:* Re: Ctrl C in SQLPlus exits Windows
>
> Ram,
>
> Are you executing sqlplus from within another program such as
> sqldeveloper?  (Like execute SQL as a script)
>
> The only time I've seen control-c exit sqlplus is if SQLplus is
> executed from another program.
>
> If you call sqlplus from the command prompt, I believe Ctrl-C will
> interrupt as normal.   You can save your sql scripts as ".sql" files
> if you're writing them in a guide and execute script as _at_script or
> _at_<path to script>/script.sql .
>
> Chris
>
> On Sun, Mar 10, 2019, 1:59 AM Ram K <lambu999_at_gmail.com
> <mailto:lambu999_at_gmail.com>> wrote:
>
> Installed Oracle in my home Windows PC and playing around with it.
> But pressing Ctrl-C always exits SQL Plus, when I run queries.
> grr... Tried searching online and found  this:
>
> https://grokbase.com/t/freelists.org/oracle-l/095myarkwd/11g-sqlplus-on-windows-and-ctrl-c
>
> Is there a solution for Ctrl C only to interrupt and not to exit
> SQL Plus in windows.
>
> --
>
> Thanks,
> Ram.
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l