Re: Spool

Hi Shiva-

Please create an account with ToadWorld.com and move future posts there.  This Yahoo Group will soon be close permanently.

thanks
Mark

--- In [email protected], SHIVANAND BHARTI <SBharti@...> wrote:
>
> Hi folks ... I have a query with bind variable which accepts date.
> How can I run thais query for 30 different dates and get it's output in a file.
> 
> I can write the same query 30 times with different date and run it as ascript.
> Or write a PL/SQL block.
> 
> But it is an one time thing and I am looking for something quick .
> Is there an option in Toad by which I can spool out the output of a query for different input for the same bind variable ?
> 
> For example how can I run this query for 30 different dates and spool  it's output.
> 
> SELECT  :RunDate   ,
>       ( SELECT COUNT(*)
>            FROM store
>           WHERE pstore_open_date =:RunDate  ) store_count
>       ,( SELECT COUNT(*)
>            FROM wh
>           WHERE wh_open_date =:RunDate  ) ) wh_count
>   FROM dual;
> 
> 
> Thanks,
> Shiva
> 
> 
> 
> -------------------------------------------------------------------------------------
> 
> NOTE: This e-mail message contains PRIVILEGED and CONFIDENTIAL information and is intended only for the use of
> the specific individual or individuals to which it is addressed. If you are not an intended recipient of this
> e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the
> information contained herein or attached hereto is strictly prohibited. If you receive this e-mail in error,
> notify the person named above by reply e-mail and please delete it. Thank you.
>




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/