RE: SQLPlus -- replacement tool
- From: "John Flack" <JohnF@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Feb 2004 19:08:33 -0500
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:
1. The usual set of control structures, but lets start with an "if =
else" so that I can write conditional execution.
2. A way to set default values for substitution variables.
3. 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@xxxxxxxxxxxxxxxx]
Sent: Friday, February 20, 2004 5:26 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
