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 Report

SQL Report

From: Praveen <nospam_at_spam.com>
Date: Tue, 06 May 2003 05:19:37 GMT
Message-ID: <3EB7466A.2020407@spam.com> 





Hi..All,



    I have 2 tables employee (employeeid), dept (dept_id, ,employeeid). 
I want to get a report in the following format



<dept_id1>


employeeid1


employeeid2


...

...




<dept_id2>


employeeidXX


employeeidYY


....

...

..





Is this possible to do it in a single SQL.



Regards,



P
Received on Tue May 06 2003 - 00:19:37 CDT












Original text of this message













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