Re: interactive SQL plus script

Hello,
I hope this helps you.

SQL> select * from billingdata where call_datetime = &date; Enter a value for date:

Bye

sandy weinberg escribió en mensaje <370c6ca5.91671868_at_194.151.75.233>...
>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:56:26 CEST