I would like to create a package that runs a simple query that will prompt me for input dates at runtime ( < BEG_DT > and < END_DT > ) if possible. The results will be written to a txt file.
select * from TABLE1
where FIELD1= '00478850'
and DATE_FIELD between < BEG_DT >and < END_DT >
Any suggestions would be appreciated.
Thank you.
select * from TABLE1
where FIELD1= '00478850'
and DATE_FIELD between < BEG_DT >and < END_DT >
Any suggestions would be appreciated.
Thank you.
