RE: SQLPlus -- replacement tool

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Mon, 23 Feb 2004 10:01:40 -0600
Message-ID: <00eb01c3fa26$570766f0$6601a8c0@CVMLAP02>

J*n,

Here's a partial list of what I'm talking about...

Augment the VARIABLE command so that it can accept a value.
Provide an all-inclusive method for saving SET variable values as in PUSHENV and POPENV.
Provide a command that determines whether a DEFINE value exists.
Provide a command that allows one to inspect VARIABLE values and DEFINE values without having to execute SQL. This command is the basis of flow control.
Provide named statement buffers.
Add a new SET variable that determines the number of cached cursors. Use an LRU algorithm for aging cursors.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle

Hotsos Symposium 2004: March 7-10 Dallas
Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Flack Sent: Friday, February 20, 2004 6:09 PM
To: oracle-l_at_freelists.org
Subject: RE: SQLPlus -- replacement tool

Even though you directed this at Cary, and I'm interested in seeing his =
response, here are a few things I'd like to see:

The usual set of control structures, but lets start with an "if = else" so that I can write conditional execution.
A way to set default values for substitution variables.
I know how to get the result of a single row query into variables, = but I'd like an easier more straightforward method, like: SELECT to_char(SYSDATE) INTO today;

-----Original Message-----
From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com] Sent: Friday, February 20, 2004 5:26 PM
To: oracle-l_at_freelists.org
Subject: Re: SQLPlus -- replacement tool

Could you please give an example of how you would like the tool work = like.
----- Original Message -----=20
From: "Cary Millsap" <cary.millsap_at_hotsos.com> To: <oracle-l_at_freelists.org>
Sent: Friday, February 20, 2004 6:01 PM
Subject: RE: SQLPlus -- replacement tool

Juan,

It's an issue of writing a complete interactive application, which is just really nasty in sqlplus. Dbms_output is inadequate on the output side, and using "&" and "&&" in the input side is even worse than that...

"Nullius in verba" means, "Don't take anybody's word for it." It has been the motto of the Royal Society of England for a few centuries.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Feb 23 2004 - 10:01:03 CST