Re: TOAD For Oracle - Question

OracleNewbie wrote:
> I'm using TOAD to connect to oracle. I want to execute 2 select
> statment in the sql editor and want to see the see the results one
> after the other. Like
>
> Select Name, City From PhoneBook;
> Select * from CityDetails;
>
> Name City
> XXX Boston
> YYY Woburn
>
>
> No. CityName Population AvgTemp
> 1 Boston 450000 40
> 2 Woburn 250000 42
>
> I can do the same thing using Query Analyzer for SQL Server. But how
> can i do this in TOAD for oracle. Appreciate the help.
>
> Thanks

Not sure you can. But why are you using two queries to do what you could do with one? Just create an inner join between the two tables.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)