Re: multiple queries in toad

openwound5000_at_aol.com (Open Wound) wrote in message news:<e33ccdb5.0406231305.7d8f3ff6_at_posting.google.com>...
> cambridgeways_at_hotmail.com (Cambridgeways) wrote in message news:<e0774553.0406191553.4637d3d1_at_posting.google.com>...
> > I'm new to Toad (free version). I would like to execute a series of
> > SQL statements like this:
> >
> > select table_code, table_val from address_types;
> >
> > select table_code, table_val from name_types;
> >
> > When I select either one and select 'Execute Current SQL' it runs.
> > When I select 'Execute SQL All', I get an error 'ORA-00911: invalid
> > character' and the first statement is highlighted until the semicolon.
> > So it seems to be objecting to the semicolon. When I select 'Execute
> > SQL Window Via SQL Plus', both statements run successfully.
> >
> > Am I missing a setting somewhere that would allow Toad to understand
> > that I want multiple statements to run? Any help is appeciated.
>
>
> You can surround multiple statements with a BEGIN and an END; to execute
> at them at once. However, it appears you are trying to display multiple
> resultsets (tables) in one grid at the same time. Toad doesn't support
> this. Why do you want multiple tables to be displayed in the grid at the
> same time?

I want to have in one continuous document a list of lookup tables without cutting and pasting results. Anyway, I've determined that this is probably not supported, at least not in the free version. I just wish the help file were more explicit since the menu commands imply a certain functionality. Thanks for responding. Received on Fri Jun 25 2004 - 01:20:51 CEST