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
Received on Sat Feb 21 2004 - 23:04:02 CST
