Re: Question about SQL query

If you use SQL*Plus look at "SQL*Plus User’s Guide and Reference" book, "Writing Interactive Commands" topic.

Hope this helps.

LAKSHNE wrote:
>
> 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 'aa%';
>
> 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
> books about SQL but they don't say a whole lot about interactive
> programming.
>
> Thanks in advance for your help!
>
> Sincerely yours,

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru