need help in update statement

[gopu_g]

create a view
select sysdate as nav_date
from dual ?

like citldba said

you create a view

create view time_view as ( SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') "Current date" FROM dual);

it will get update.
In the case of table, it is created with the time while you firing the create query.so when you select from the table you will get the time already stored at the time of creation,again it wont go to select from the dual.