need help in update statement

[gopu_g]

AGAIN - WHY?

whay create a view on dual - whats the point!

And why do you think it wont select from dual

dave,

when i tried it from the table it is not doing.But it is working fine in the view.
can you post the correct query for the table ??

[/QUOTE]
- wtf do you think the view is doing?[/QUOTE]

yes the view is doing

SQL> select * from time_view;

Current date
--------------------
24-JUN-2008 06:08:03

SQL> /

Current date
--------------------
24-JUN-2008 06:08:07

SQL> /

Current date
--------------------
24-JUN-2008 06:08:09