RE: Something i'm missing

From: <Joel.Patterson_at_crowley.com>
Date: Wed, 15 Aug 2007 14:46:54 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B033FF1C1@jax-mbh-01.jax.crowley.com>

How about using '%' (for strings anyway). And change = to like

where blah_col like '&blah_variable';

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

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 - 13:46:54 CDT