RE: Re[2]: SQLPlus -- replacement tool
- From: "John Flack" <JohnF@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 22 Feb 2004 00:06:50 -0500
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
-----------------------------------------------------------------
Other related posts:
