-
Hi,
I am runing a query through out the night.. how
can I know when the query is done.
-
Could we get a little more explanation?
If you want to know how long one specific query took in a sqlplus script, use:
SQL> set timing on
SQL> select count(*) CNT from myTable;
CNT
-----------
12
Elapsed: 00:00:00.1
SQL>
Jeff Hunter
-
Hi,
actually I am trying to create a table using couple of views.
SQL> create table mytable as select * from myview.
and I am trying to figure out how long did it take to create
mytable.
thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|