Re: Separate cursor for bind value assignment, is this normal
From: Andy Sayer <andysayer_at_gmail.com>
Date: Fri, 21 Sep 2018 12:21:36 +0100
Message-ID: <CACj1VR6_hq45zJS6koCgqZwAo9v17B0nSLc77iM99OWcS=XyPQ_at_mail.gmail.com>
Date: Fri, 21 Sep 2018 12:21:36 +0100
Message-ID: <CACj1VR6_hq45zJS6koCgqZwAo9v17B0nSLc77iM99OWcS=XyPQ_at_mail.gmail.com>
This has been addressed in later versions of sql*plus, you can use the new
syntax
In
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
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 21 2018 - 13:21:36 CEST