Re: Separate cursor for bind value assignment, is this normal

hi Andy,
That is very interesting to know. I am on 12.1.0.2 , so out of luck there. You mentioned PL/SQL in your blog , i will test it out. Very nice writeup!

Thanks!

On Fri, Sep 21, 2018 at 7:21 AM Andy Sayer <andysayer_at_gmail.com> wrote:

> This has been addressed in later versions of sql*plus, you can use the new
> syntax
> var x number = 31
> It will do all the bind assignment locally rather than on the DB, so you
> don’t do the extra parse
>
> In
> https://ctandrewsayer.wordpress.com/2017/03/29/sqlplus-12-2-so-close/ , I
> mention that it lacks the ability to assign a value by defined variable,
> this feature is still lacking in SQL*PLUS 18.2
>
> Hope this helps,
> Andy
>

-- 
Cheers,
Kunwar

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