RE: Separate cursor for bind value assignment, is this normal
Date: Mon, 8 Oct 2018 22:49:41 +0000 (UTC)
Message-ID: <289969d0-355a-4a91-a1f5-0b95b0f80f8a_at_default>
If you want to write some code and do some oracle, SQLcl has access to javascript, jython, groovy, etc. I’m sure there’s a way to init a bind there
From: Mark W. Farnham <mwf_at_rsiz.com>
Sent: Monday, October 8, 2018 5:26 PM
To: orahawk_at_gmail.com; contact_at_soocs.de
Cc: krishsingh.111_at_gmail.com; Oracle - L <oracle-l_at_freelists.org>
Subject: RE: Separate cursor for bind value assignment, is this normal
hehe, which started as the ufi (user friendly interface), which some customers called the uvi (user viscious interface) for things like its lack of a history buffer and so forth.
You are correct that it was never intended as a programming tool. Oracle had Pro*C for amateurs and the C call libraries for professionals. And at 300 baud, you had better figure out a way to avoid telecom line turn-arounds in the middle of a transaction, too, and with 25 MHz cpus and table locking you better avoid parses in the middle of transactions, too.
UFI was competitive with its competition as a quick way to ask the database quick questions.
mwf
From: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dragutin Jastrebic
Sent: Monday, October 08, 2018 2:18 PM
To: HYPERLINK "mailto:contact_at_soocs.de"contact_at_soocs.de
Cc: HYPERLINK "mailto:krishsingh.111_at_gmail.com"krishsingh.111_at_gmail.com; Oracle - L
Subject: Re: Separate cursor for bind value assignment, is this normal
Hello
In this old thread=>
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:113012348062
Tom Kyte explained
==>
.... in sqlplus the exec :x := &x will be parsed each time,
those will be unavoidable (sqlplus is not a programming environment, it is just a simple command line tool)
Yes, I wish sqlplus had a way to initialize a bind variable -- it would be nice.
<===
So possibly that it was event a design choice of Oracle development team, since sqlplus was more seen a command line tool, not a programming tool.
Dragutin
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 09 2018 - 00:49:41 CEST