Following is from stdbody.sql. Now select sysdate from dual is used only
when pessdt returns NULL.
-- Bug 1287775: back to calling ICD.
-- Special: if the ICD returns NULL, that means we should do the old
-- 'SELECT SYSDATE FROM DUAL;' thing. This allows us to do the SELECT
from
-- PL/SQL rather than having to do it from C (within the ICD.)
function sysdate return date is
d date;
begin
d := pessdt;
if (d IS NULL) then
select sysdate into d from sys.dual;
end if;
return d;
end;
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 26, 2002 11:03 AM
> Actually this may not be true any more starting from Oracle 8.1.7.
>
> Many of the functions started to have a C language interface in 8.1.7.
>
> Check stdbody.sql to find which function has a C prgama.
>
> Regards,
>
> Waleed
>
> -----Original Message-----
> Sent: Thursday, December 26, 2002 1:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Raj:
>
> Both are same. It is internally translated as a select call to dual.
>
> KG
>
> --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> > Can someone please explain me why you have to use
> >
> > select sysdate
> > from dual
> > /
> >
> > when
> >
> > my_date_Var := sysdate;
> >
> > just works fine? Maybe I am clueless ... but I can take an
> > explanation
> >
> > Raj
>
> =====
> Have a nice day !!
> ------------------------------------------------------------
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: K Gopalakrishnan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Khedr, Waleed
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shaleen
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
