in oracle, join table a and b on col, which is a nullable column a.col = b.col doesn't match all ( a.col is null and b.col is null ) OR ( a.col is not null and b.col is not null and a.col = b.col ) does nvl(a.col, 'N/A') = nvl( b.col, 'N/A') seems work, but if a.col is null and b.col is 'N/A', then it will fail. What's the best way to compare them?
【在 c**t 的大作中提到】 : in oracle, join table a and b on col, which is a nullable column : a.col = b.col doesn't match all : ( a.col is null and b.col is null ) : OR : ( a.col is not null and b.col is not null and a.col = b.col ) : does : nvl(a.col, 'N/A') = nvl( b.col, 'N/A') seems work, but if a.col is null and : b.col is 'N/A', then it will fail. : What's the best way to compare them?
【在 c**t 的大作中提到】 : in oracle, join table a and b on col, which is a nullable column : a.col = b.col doesn't match all : ( a.col is null and b.col is null ) : OR : ( a.col is not null and b.col is not null and a.col = b.col ) : does : nvl(a.col, 'N/A') = nvl( b.col, 'N/A') seems work, but if a.col is null and : b.col is 'N/A', then it will fail. : What's the best way to compare them?
l*e
16 楼
the jade pendent in ur icon is so beautiful..more pics?
【在 c**t 的大作中提到】 : in oracle, join table a and b on col, which is a nullable column : a.col = b.col doesn't match all : ( a.col is null and b.col is null ) : OR : ( a.col is not null and b.col is not null and a.col = b.col ) : does : nvl(a.col, 'N/A') = nvl( b.col, 'N/A') seems work, but if a.col is null and : b.col is 'N/A', then it will fail. : What's the best way to compare them?
Use another string then. e.g. nvl(a.col,'NULL')=nvl(b.col,'NULL') or even use the following if you like, nvl(a.col,'Fuck off, it is null')=nvl(b.col,'Fuck off, it is null')
and
【在 c**t 的大作中提到】 : in oracle, join table a and b on col, which is a nullable column : a.col = b.col doesn't match all : ( a.col is null and b.col is null ) : OR : ( a.col is not null and b.col is not null and a.col = b.col ) : does : nvl(a.col, 'N/A') = nvl( b.col, 'N/A') seems work, but if a.col is null and : b.col is 'N/A', then it will fail. : What's the best way to compare them?
l*r
31 楼
Wooo, excellent collection, high-end. As for Monkey, no problem.
以邮养邮 is hard for me. I haven't completed a full run of China stamps yet, so I don't have many duplicates to trade for profit. I spent most of time last couple of years in Republic of China and Qing, the album still remains a lot of blank spaces to fill in. Can you elaborate an example, how can you get a free Monkey by trading?
【在 l*****r 的大作中提到】 : 以邮养邮 is hard for me. I haven't completed a full run of China stamps yet, : so I don't have many duplicates to trade for profit. I spent most of time : last couple of years in Republic of China and Qing, the album still remains : a lot of blank spaces to fill in. : Can you elaborate an example, how can you get a free Monkey by trading?
The Monkey has no problem. I spent 2 years to study monkey, the middle one can not be fake. Remember that the monkey was printed with multiple imprint, with multiple layers of ink. It is very normal to have a little bit offset between hairs and background here and there. The face of monkey may change a little bit from one to another. All are normal.
My husband was 45 when I married him with the age of 21. I am very happy because he lost his first wife with no child and he is an owner of big private inductry in USA.
h*s
150 楼
这样你很亏啊,45岁的男人找个35岁的女人他都会高兴。
【在 W***9 的大作中提到】 : My husband was 45 when I married him with the age of 21. I am very happy : because he lost his first wife with no child and he is an owner of big : private inductry in USA.
N*f
151 楼
楼上几位说得不无道理,不过二十郎当岁就把退休之后当作第一要务,还是未免 过虑。况且老太太无人问津并非命里定数,还是因人而异。跟俺多年相熟的一位 意大利裔老太太几年前六十岁上突然决定跟结发老公离婚,前几天给俺发e-mail 说:“I never knew before that life could be so much fun!” 归根结底,来日方长,enjoy life要紧。不管老男人小男人,在一起开心就是好男 人。
【在 N****f 的大作中提到】 : 楼上几位说得不无道理,不过二十郎当岁就把退休之后当作第一要务,还是未免 : 过虑。况且老太太无人问津并非命里定数,还是因人而异。跟俺多年相熟的一位 : 意大利裔老太太几年前六十岁上突然决定跟结发老公离婚,前几天给俺发e-mail : 说:“I never knew before that life could be so much fun!” : 归根结底,来日方长,enjoy life要紧。不管老男人小男人,在一起开心就是好男 : 人。