multiple queries in toad
Cambridgeways
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.
Anon-o-mouse
(Cambridgeways) wrote:
You need to select the execute as a script option.
--
Cambridgeways
Anon-o-mouse
(Cambridgeways) wrote:
>Anon-o-mouse <Anono...@notmail.com> wrote in message news:<n2fbd0tsftq78gurh...@4ax.com>...
-- deleted to preserve my sanity.....
>> --
>I tried this but nothing appears in the results grid.
OK ... that is because this is not output to the grid.
If you want the output to the grid... I believe you need to have a
single query.
(you could try a union all .. as long as the returned columns are the
same)
*shrug*
this is the best advice I can offer ... aside from running seperate
queried & cut/paste results to some other product.
Open Wound
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?
Cambridgeways
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.