Re[2]: SQLPlus -- replacement tool
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: John Flack <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Feb 2004 20:35:00 -0500
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,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@xxxxxxxxxxx and
include the word "subscribe" in either the subject or body.
----------------------------------------------------------------
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:
