Re: How can I select all IDs from a Column, when I dont have any Values

select id,name from table where id is not null   OR
(assume ID is a positive number)
select id,name from table where id > 0

amir_at_have-it.de (amir) wrote:

>Hi,
>
>I am looking for a Asterix like % for the Number Datatype.
>
>Example:
>
>For a Varchar-Column:
>select id, name from table where name like '%';
>
>For a Number-Column:
>select id, name from table where id = ????
>
>Wie use Oracle 8.1.
>Thanks
>Amir

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Nov 30 2001 - 08:31:38 CST