Using sysdate as a paramter

[ClowneUser]

Hi,

I'm new to Oracle / plsql I'm trying to find a way to write a simple query but use sysdate as a default parameter, but this parameter can be changed by the user if necessary.

Thanks,

Mick.

 

[Beilstwh]

use a DEFINE VARIABLE

select count(*)
from so
where so_wr_dt > nvl(to_date('&my_date','MM/DD/YYYY'),TRUNC(SYSDATE))
SQL> /
Enter value for my_date:
old 3: where so_wr_dt > nvl(to_date('&my_date','MM/DD/YYYY'),TRUNC(SYSDATE))
new 3: where so_wr_dt > nvl(to_date('','MM/DD/YYYY'),TRUNC(SYSDATE))

COUNT(*)
----------
0

SQL> /
Enter value for my_date: 02/01/2018
old 3: where so_wr_dt > nvl(to_date('&my_date','MM/DD/YYYY'),TRUNC(SYSDATE))
new 3: where so_wr_dt > nvl(to_date('02/01/2018','MM/DD/YYYY'),TRUNC(SYSDATE))

COUNT(*)
----------
758703

Bill
Lead Application Developer
New York State, USA