Output a timestamp between actions in a stream of SQL in the editor

Toad for Oracle & DevOps Toolkit
1

I’ve got what is essentially a batch process that I run in the editor. What I’d like is the proper statement to output the current time between each of the action queries.

2

I don’t know what you mean by a batch process in the editor, but if you’re just running SQL statements why don’t you just put select sysdate from dual between
the commands and run as a script (F5)?

select
*

from
scott.emp;

select
to_char(sysdate,‘MM/DD/YY HH:MI’)
from dual;

select
*

from
scott.dept;

select
to_char(sysdate,‘MM/DD/YY HH:MI’)
from dual;

From: oaksong [mailto:bounce-chris_078@toadworld.com]

Sent: Tuesday, March 18, 2014 4:36 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Output a timestamp between actions in a stream of SQL in the editor

Output a timestamp between actions in a stream of SQL in the editor

Thread created by oaksong

I’ve got what is essentially a batch process that I run in the editor. What I’d like is the proper statement to output the current time between each of the action queries.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

There is another way of measuring time-timing command from sqlplus.This command tells you how much each statement lasted. This is command is no PL/SQL available.:

set timi on
select 1 from dual;
select count(*) from dba_tables;

output looks like:

1

     1

1 row selected.
Elapsed: 00:00:00.01

COUNT(*)

  3303

1 row selected.
Elapsed: 00:00:00.23

To disable timing:
set timi off