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_colfrom blah_tablewhere 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 http://www.mail.com ! Get a FREE E-mail Account Today - Choose From 100+ Domains

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 15 2007 - 09:42:56 CDT