when Query is done ??

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>

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,