It is 8.1.7.4, it doesn't do the select sysdate from dual anymore for dt:=sysdate;
Anjo. On Thursday 26 December 2002 12:59, you wrote: > That's because doing dt := sysdate is more optimized, it's still select > sysdate into dt from dual but more optimized. select from dual doing 4 db > block gets in 8i and 2 db block gets in 9i, but you can tune it to cut it > down. > > Richard Ji > > -----Original Message----- > Sent: Thursday, December 26, 2002 2:45 PM > To: Multiple recipients of list ORACLE-L > > > > > That's what I thought too. But the results of testing are somewhat > different. > Maybe it's evaluated within the PL/SQL engine and does not require a > context > > switch to the SQL engine. > > Platform : Sun Solaris 2.6 > Oracle : 8.1.7.4 (32 bit) > > DEV:43#14739-23049>@dual1 > DEV:43#14739-23049>declare > 2 dt date; > 3 begin > 4 > 5 for i in 1..10000 > 6 loop > 7 select sysdate into dt from dual; > 8 -- dt := sysdate; > 9 end loop; > 10 end; > 11 / > > PL/SQL procedure successfully completed. > > Elapsed: 00:00:01.97 > > > DEV:43#14739-23049>@dual1 > DEV:43#14739-23049>declare > 2 dt date; > 3 begin > 4 > 5 for i in 1..10000 > 6 loop > 7 -- select sysdate into dt from dual; > 8 dt := sysdate; > 9 end loop; > 10 end; > 11 / > > PL/SQL procedure successfully completed. > > Elapsed: 00:00:00.92 > > > Regards, > Denny > > Quoting K Gopalakrishnan <[EMAIL PROTECTED]>: > > 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: Anjo Kolk 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).
