SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I use SYSDATE in the WHERE clause to limit the date range of a query

516377Jun 3 2006 — edited Jun 3 2006

Hi,

Basicaly the subject title(Can I use SYSDATE in the WHERE clause to limit the date range of a query) is my question.
Is this possible and if it is how can I use it. Do I need to join the table to DUAL?

Thanks in advance.
Stelios

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2006

Added on Jun 3 2006

7 comments

1,697 views