RE: Something i'm missing

Something like this?  

Tanel_at_Sol01> select count(*) from all_users where username = nvl( '&enter_user_name', username);
Enter value for enter_user_name: SYSTEM  

  COUNT(*)

         1  

1 row selected.  

 <mailto:Tanel_at_Sol01> Tanel_at_Sol01> select count(*) from all_users where username = nvl( '&enter_user_name', username); Enter value for enter_user_name: (i just hit enter here)  

  COUNT(*)

        24    

Tanel.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyall Barbour
Sent: Wednesday, August 15, 2007 22:43
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_term= 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 - 11:11:06 CDT