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

Home -> Community -> Usenet -> c.d.o.misc -> sql query question

sql query question

From: GreyWolf_69 <GreyWolf_69_at_alloymail.com>
Date: Fri, 21 Jan 2000 09:59:35 -0500
Message-ID: <38887456.571BD9AF@alloymail.com> 





Hi,


    I was wondering if there was a way to have two different queries in
a script


that would write the results to the same line(s) in a file? The two
queries don't have


any common keys or fields.



ex:



query one: select name, id from emp;


query two: select city, temp from forcast;



ex of output that I'm looking for:



name    id      city    temp


Don    001    Taos    85



TIA,


Grey



Received on Fri Jan 21 2000 - 08:59:35 CST












Original text of this message













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