RE: Re[2]: SQLPlus -- replacement tool
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 22 Feb 2004 00:04:53 -0800
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@xxxxxxxxxxx]
> 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@xxxxxxxx)
> 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@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
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
