Thread: matching empty column
hello group: I have a table that has 500,000 rows. tar_id | mid | seq_id | lscore --------+-------+--------+-------- 32014 | | 50473 | 814 32015 | 67 | 50473 | 814 32016 | 461 | 50473 | 814 32017 | | 52964 | 857 32018 | 428 | 52964 | 822 32019 | 98 | 51208 | 737 32020 | 435 | 51208 | 737 32021 | | 51208 | 764 32022 | 98 | 41066 | 759 32023 | 431 | 41066 | 593 32024 | 250 | 41066 | 659 The mid column is empty in certain places. how can I search if there are empty spaces in mid. Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
oops ! sorry. I should not have written before thinking and referring to documentation. select * from TABLE where mid is NULL; --- Srinivas Iyyer <srini_iyyer_bioop@yahoo.com> wrote: > hello group: > > I have a table that has 500,000 rows. > > tar_id | mid | seq_id | lscore > --------+-------+--------+-------- > 32014 | | 50473 | 814 > 32015 | 67 | 50473 | 814 > 32016 | 461 | 50473 | 814 > 32017 | | 52964 | 857 > 32018 | 428 | 52964 | 822 > 32019 | 98 | 51208 | 737 > 32020 | 435 | 51208 | 737 > 32021 | | 51208 | 764 > 32022 | 98 | 41066 | 759 > 32023 | 431 | 41066 | 593 > 32024 | 250 | 41066 | 659 > > The mid column is empty in certain places. how can I > search if there are empty spaces in mid. > > Thanks. > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map > settings > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
On Thursday 24 August 2006 10:27, Srinivas Iyyer <srini_iyyer_bio@yahoo.com> wrote: > tar_id | mid | seq_id | lscore > --------+-------+--------+-------- > 32014 | | 50473 | 814 > 32015 | 67 | 50473 | 814 > The mid column is empty in certain places. how can I > search if there are empty spaces in mid. > select tar_id from table where mid is null; (assuming it's a numeric and not a text field set to '') -- Alan
On Thu, Aug 24, 2006 at 10:27:16 -0700, Srinivas Iyyer <srini_iyyer_bio@yahoo.com> wrote: > > The mid column is empty in certain places. how can I > search if there are empty spaces in mid. 'empty' is not a good word to use when referring to null values. An empty string is not the same as a null (despite what Oracle thinks).