Would like an example if my query is a join between two tables?

 

For example,

 

Select a.dept_name, b.employee_name

from dept a, emp b

where a.id = b.dept_id (+)

 

How do I define an Explicit ResultSet shape definition for the resultset
from a join

 

I'm working in Oracle.

 

Thanks,

Wing


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation, 
offer or agreement or any information about any transaction, customer 
account or account activity contained in this communication.
***********************************************************************


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to