Re: tricky SQL query (currently handled through PL/SQL)
From: bung ho <bung_ho_at_hotmail.com>
Date: 13 Jun 2003 09:31:27 -0700
Message-ID: <567a1b1.0306130831.140d5d63_at_posting.google.com>
Date: 13 Jun 2003 09:31:27 -0700
Message-ID: <567a1b1.0306130831.140d5d63_at_posting.google.com>
glad you got what you needed. one more clarification:
jetlag11235_at_yahoo.com (Jetlag) wrote in message news:<2eeed00e.0306121401.3c06d498_at_posting.google.com>...
> LINE
> 4 - "sysdate+NULL" is used to avoid an automatic cast (to_char)
> of md
you can save yourself the trouble of fetching sysdate by using
to_date(null)
to denote a null date that's compiler-friendly. Received on Fri Jun 13 2003 - 18:31:27 CEST