how to display the time used to execut SQL command

[m_shanak]

i have a Problem to know how much time the server take to execute an SQL command .

I user Oracle Db and SQL DB

thanx

[debasisdas]

if using sql*plus with oracle use the follwing

SQL> SET TIMING ON

SQL> YOUR QUERY ...........

[Arju]

YOu can use a shortcut method as well.
set timi on
By the way you can get more features from
<URL SNIPPED>

[m_shanak]

am work on a flex project ,and one of it's features is to display how much time the oracle or the data Base used to execute the query and display the time on the flex interface

[karant]

select current_timestamp from dual;

[karant]

SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS PM') As "TIME" from dual