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

Home -> Community -> Usenet -> c.d.o.server -> Abort script in SQLPLUS

Abort script in SQLPLUS

From: klabu <nosuchuser_at_gmail_dot_com>
Date: Sat, 14 Oct 2006 15:13:58 -0400
Message-ID: <12j2dnn36rpqn89@corp.supernews.com>


10gR2

How to quit a script in SQL*PLUS ?

I have this line:

ACCEPT v_inp PROMPT 'Quit (Q) or Run(R) ?'

I want the script-running aborted if v_input is Q

thanks Received on Sat Oct 14 2006 - 14:13:58 CDT

Original text of this message

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