Re: Something i'm missing

Assuming this is a number, as you don't have any quotes around &blah_variable

Just put blah_col in as the value when the prompt comes up ?

sys_at_CENTRAL> drop table t;

Table dropped.

sys_at_CENTRAL> create table t (x int);

Table created.

sys_at_CENTRAL> insert into t values (1);

1 row created.

sys_at_CENTRAL> insert into t values (2);

1 row created.

sys_at_CENTRAL> insert into t values (3);

1 row created.

sys_at_CENTRAL> commit;

Commit complete.

sys_at_CENTRAL> select * from t where x = &foo; Enter value for foo: 1
old 1: select * from t where x = &foo
new 1: select * from t where x = 1

         X

         1

sys_at_CENTRAL> select * from t where x = &foo; Enter value for foo: x
old 1: select * from t where x = &foo
new 1: select * from t where x = x

         X

         1
         2
         3

sys_at_CENTRAL>

Stefan

On 8/15/07, Lyall Barbour <lyallbarbour_at_sanfranmail.com> wrote:
>
> 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
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

--
http://www.freelists.org/webpage/oracle-l