Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: query to join two tables in 2 different Oracle schema
Turk- it's a homework assignment.
"Turkbear" <john.g_at_dot.spamfree.com> wrote in message
news:1097176920.yB2oHMJzRsN3yajM6tCHmw_at_teranews...
> harryooopotter_at_hotmail.co_ (Harry) wrote:
>
> >[x-post to c.l.p.m]
> >
> >At my work we have an Oracle 9 database sitting on a W2K server.
> >Therre are two different schema, one for overall info and the other
> >just for storing reports.
> >
> >schema A: a table "study" with study_id, etc.
> >
> >schema B: a table "report" with study_id, etc.
> >
> >How can I made a query, in SQL Plus (or PL/SQL, or Perl script)
> >that can join the table together?
> >
> >pseduo code:
> >
> > select s.study_id, r.report_type
> > from study s connected to schema A using userid xxx password yyy,
> > report r connected to schema B using userid ppp password qqq
> > where s.study_id = r.study_id
> >
> >Is it doable?
> >
> >TIA
>
> Please do not cross-post..
>
> If the data is in 2 schemas, as long as the logged in user has rights to
each schema's tables it is much simpler than you
> tried..:
>
> Select s.study.r.report_type
> from schemaA.study s, schemaB.report r
> where s.study_id = r.study_id
>
>
Received on Fri Oct 08 2004 - 11:48:27 CDT