"Set timing on" is a sql*plus command, not a SQL command. There is an
easy way in perl to emulate it:
my $start = time;
$sth->execute();
my $finish = time;
print ("It took ", $finish - $start, " seconds to execute my query.\n")'
You can include whatever you want between the $start and $finish
assignments, or even do separate ones for preparing, executing and
fetching.
____________________________
Jeff Seger
Fairchild Semiconductor
[EMAIL PROTECTED]
____________________________
[EMAIL PROTECTED]
05/04/2004 05:15 AM
To: [EMAIL PROTECTED]
cc:
Subject: oracle timming
is there a way to view/use the oracle 'set timming on' data in dbi?
if so, what is the syntax. i haven't been able to find any info regarding
that.
thanks
r
