|
||
![]() |
![]() ![]() ![]() ±×³É nvl·Î ó¸®Çصµ µÉµí
2019-03-31
![]()
|
![]() |
![]() ![]() AGEÇʵ尡 NOT NULLÀÏ °æ¿ì WHERE AGE = DECODE(:age, NULL, AGE, :age)
AGEÇʵ尡 NULLÀÏ °æ¿ì WHERE 1=DECODE(:age, NULL, 1, 2)UNION ALL WHERE 2=DECODE(:age, NULL, 1, 2) AND AGE = :age
2019-04-02
![]()
|
![]() |
![]() ![]()
¿À..DECODE´Â óÀ½º¸³×¿ä °¨»çÇÕ´Ï´Ù !
2019-04-03
![]()
|
|
|
![]() |
![]() | ¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â | ![]() |
where case when :age is null then 1 else age end = case when :age is null then 1 else :age end