RE: Something i'm missing
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Aug 2007 14:46:54 -0400
How about using '%' (for strings anyway). And change = to like
where blah_col like '&blah_variable';
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lyall Barbour
Sent: Wednesday, August 15, 2007 10:43 AM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
