need help in update statement

Quote:

---

Originally Posted by davey23uk

select sysdate from dual - will return the date

its up to the CLIENT to say how it wants it displayed

---

yes davey you are rite :), we will get the sysdate from the dual.

but the poster ali560045 needs the time to display it from the table he created, and whenever he select from the tabe he needs the updated time(current time).but it is happening only from the view.

SQL> select * from time_table;

Current date
--------------------
24-JUN-2008 03:04:29

SQL> select * from TIME_VIEW;

Current date
--------------------
25-JUN-2008 09:44:42

SQL> select * from TIME_VIEW;

Current date
--------------------
25-JUN-2008 09:44:51

If we are creating table with "select sysdate from dual" command. Table contains static data. Then if you query from your created table then you will get old date (when table was created and selected sysdate from dual).
If you are creating view then it is dynamic and will give you current date.

my god!

there is no need to create the table in the first place - do not do it - it is dumb, it serves no purpose, it solves no problem, just select straight from dual - its what it is ther for!

A view is of no use, do not do it, it is dumb, it serves no purpose, it solves no problem

you are rite davey:),but the poster requirement is something like that :).