Re: SQLPlus + PL/SQL
From: Karen Kluge <kakluge_at_ucdavis.edu>
Date: Wed, 22 Apr 1998 08:46:14 -0700
Message-ID: <353E10C5.160B3B30_at_ucdavis.edu>
Date: Wed, 22 Apr 1998 08:46:14 -0700
Message-ID: <353E10C5.160B3B30_at_ucdavis.edu>
dpavlis_at_azerty.com wrote:
> Is it possible to combine in SQLPlus script together commands from
> PL/SQL an
> SQLPlus internal commands ??
> For instance such a piece of code:
>
> ACCEPT v_Num NUMBER PROMPT 'Enter number:'
> IF v_Num = 1 THEN .......
> ENDIF
> PROMPT v_Num
Yes you can, but you'll need to enclose your PL/SQL with BEGIN and END and you'll need a / in the script to get it to execute the PL/SQL. Something like this:
ACCEPT v_num NUMBER PROMPT 'Enter number: '
BEGIN
IF &v_num = 1 THEN...
END IF;
END;
/
Received on Wed Apr 22 1998 - 17:46:14 CEST