Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Something i'm missing
Select blah_col from blah_table where
blah_col=nvl('&blah_variable',blah_col);
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak_at_il.proquest.com <mailto:mark.bobak_at_il.proquest.com>
www.proquest.com <http://www.proquest.com>
www.csa.com <http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyall Barbour
Sent: Wednesday, August 15, 2007 10:43 AM
To: oracle-l_at_freelists.org
Subject: Something i'm missing
Hey everybody,
This is probably something easy and simple i'm missing. I'm using the & in the WHERE clause of a query to get certain information. How do i get ALL the information, too. Essentially, blanking out the where clause.
select blah_col
from blah_table
where blah_col = &blah_variable;
When the prompt comes up, if i just want all in info, is it possible to get this? I just hit enter and didn't work.
Lyall
--
We've Got Your Name at Mail.com
<http://www.mail.com/?utm_source=mail_sent_footer&utm_medium=email&utm_t
erm=070621&utm_content=textlink&utm_campaign=we_got_your_name>
Get a FREE E-mail Account Today - Choose From 100+ Domains
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2007 - 10:42:51 CDT
![]() |
![]() |