Dates Help!!

I need help with dates and SQL. When I try to write a 'select' statement which calls for the SysDate from 'DUAL' oracle tells me that DUAL does not exist, I had believed that 'DUAL' is preset table which can not be deleted in oracle.

Also the SQL statement which I am trying to write calls, for the user to enter a date within a program and then for oracle to search for all data between the user's date, and theh 'SysDate', any help on how to write this is greatly appreciated.

thanks
clarke Received on Mon Jul 01 1996 - 00:00:00 CEST