Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: SQLPlus -- replacement tool

Re[2]: SQLPlus -- replacement tool

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Feb 2004 20:35:00 -0500
Message-ID: <152105358837.20040220203500@gennick.com>


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,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

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_at_gennick.com 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_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 Fri Feb 20 2004 - 19:32:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US