Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: TOAD For Oracle - Question

Re: TOAD For Oracle - Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 05 Jan 2006 09:26:09 -0800
Message-ID: <1136481966.633922@jetspin.drizzle.com>


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)
Received on Thu Jan 05 2006 - 11:26:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US