| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: SQLPlus -- replacement tool
For the last several year I have used Perl when
something needs to be interactive.
Term::Readline works quite well.
Jared
On Sat, 2004-02-21 at 21:06, John Flack wrote:
> You can still do this - just make it into PL/SQL by adding a BEGIN and END:
> variable today VARCHAR2(10)
> BEGIN
> SELECT TO_DATE(SYSDATE,'mm/dd/yyyy') INTO :today;
> END;
> /
> But, then you have to get the bind variable into a substitution variable. I liked the addition of bind variables to SQL*Plus, but they can confuse the uninitiated. I wish there was only one kind of variable.
>
> -----Original Message-----
> From: Jonathan Gennick [mailto:jonathan_at_gennick.com]
> Sent: Fri 2/20/2004 8:35 PM
> To: John Flack
> Cc:
> Subject: Re[2]: SQLPlus -- replacement tool
>
>
>
> Friday, February 20, 2004, 7:08:33 PM, John Flack (JohnF_at_smdi.com) wrote:
> JF> 3. I know how to get the result of a single row query into variables, =
> JF> but I'd like an easier more straightforward method, like:
> JF> SELECT to_char(SYSDATE) INTO today;
>
> You used to be able to do this using bind variables. For
> example:
>
> variable x varchar2(10)
> select dummy into :x from dual;
> print x
>
> This used to work, but somewhere along the line it stopped
> working. I'm not sure why. But it's really no help anyway,
> for what you are talking about, because bind variables live
> in a different world from define variables.
>
> Best regards,
>
> -- Binary/unsupported file stripped by Ecartis --
> -- Type: application/ms-tnef
> -- File: winmail.dat
>
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
-- 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 Sun Feb 22 2004 - 01:56:54 CST
 |
 |