Jan 25 2008 05:44 AM 5191 6 Time taken by a query madhupriya.nukala What is the command to print the time taken by a query hemant.agarwal03 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03 Feb 13th, 2008 you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time.. karunakaradepu Profile Answers by karunakaradepu Questions by karunakaradepu Jan 29th, 2008 If UR Q is How TO PRINT A TIME: SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL; Answer Question Select Best Answer
Jan 25 2008 05:44 AM 5191 6 Time taken by a query madhupriya.nukala What is the command to print the time taken by a query hemant.agarwal03 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03 Feb 13th, 2008 you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time.. karunakaradepu Profile Answers by karunakaradepu Questions by karunakaradepu Jan 29th, 2008 If UR Q is How TO PRINT A TIME: SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL; Answer Question Select Best Answer
hemant.agarwal03 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03 Feb 13th, 2008 you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time..
karunakaradepu Profile Answers by karunakaradepu Questions by karunakaradepu Jan 29th, 2008 If UR Q is How TO PRINT A TIME: SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL;