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

From: kunwar singh <krishsingh.111@xxxxxxxxx>
To: andysayer@xxxxxxxxx
Date: Fri, 21 Sep 2018 08:37:46 -0400

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@xxxxxxxxx> 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

Follow-Ups:
- Re: Separate cursor for bind value assignment, is this normal
  - From: Stefan Koehler

References:
- Separate cursor for bind value assignment, is this normal
  - From: kunwar singh
- Re: Separate cursor for bind value assignment, is this normal
  - From: kunwar singh
- Re: Separate cursor for bind value assignment, is this normal
  - From: Stefan Knecht
- Re: Separate cursor for bind value assignment, is this normal
  - From: Andy Sayer

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

Other related posts: