Re: ACCEPT in SQL*Plus script

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 3 Feb 2005 05:32:11 -0800
Message-ID: <1107437531.903635.297560@c13g2000cwb.googlegroups.com>

Andy Kent wrote:
> Thanks for your reply but I don't know what you mean - there is
already
> an EOF in the example, are you saying just move the accept down to
the
> bottom of the code? If so how will the update know what the value is?
>
> Andy

I think what he means by interactive session is to move the code and connect string to a sql script then,
sqlplus /nolog @yourscript
This will prompt the user for input.

Regards
/Rauf Received on Thu Feb 03 2005 - 07:32:11 CST