Re: Length of SQL execution in SQL plus

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Nov 2006 10:22:05 -0800
Message-ID: <1163442125.047263.257730@m73g2000cwd.googlegroups.com>

On Nov 13, 12:44 pm, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> Hello!
>
> I need to know the length of the execution of an SQL statement in Oracle SQL
> worksheet. I know there is a command to set a flag on but I do not remember
> the name of the command anymore.
>
> Regards,
> Norbert

When you know a feature exists but cannot remember what it is then pull the documentation. What you want is the timing option of the set command:

set timing on

HTH -- Mark D Powell -- Received on Mon Nov 13 2006 - 12:22:05 CST