Re: interactive SQL plus script

in SQL*Plus use Substitution variables starting with &

Heike
> -----Ursprüngliche Nachricht-----
> Von: sweinberg_at_callmax.nl (sandy weinberg)
> [mailto:sweinberg_at_callmax.nl]
> Veröffentlicht um: Donnerstag, 8. April 1999 10:50
> Veröffentlicht in: tools
> Unterhaltung: interactive SQL plus script
> Betreff: interactive SQL plus script
>
> I am a beginner in SQL queries and have created following script:
>
> select number, call_datetime date, input_source
> from billingdata
> where input_source like 'NN%';
>
> When the script is run I would like to enter a begin and end date for
> using the variable call_datetime.
>
> Can someone tell me how to do this, I'm still looking through my 2
> books about SQL but they don't say a whole lot about interactive
> programming.
>
> Thanks in advance for your help!
>
> Sincerely yours,
>
> Sandy.
>
>
Received on Thu Apr 08 1999 - 11:30:51 CEST