Re: interactive SQL plus script

if its going to users you can add the line

accept START_DATE prompt 'Enter Start Date : '

then user

select *
from xxx
where sd_date = '&start_date'

if you need to use it more than once look up && and use define and undefine to set and reset the variables

Steve Received on Thu Apr 08 1999 - 13:09:26 CEST