Re: Simple query not executing on Oracle

      If you want to do a remote statement the sintax should be:

         select *
         from XYZTable_at_database1 a,
              XYZTable_at_database2 b
         where a.fld1 = b.fld1;

      HIH,

         Aram.

In article <7085fv$cqu$1_at_nnrp1.dejanews.com>,   ravisk12_at_my-dejanews.com wrote:
> Thank you very much for your prompt and usefull response.. Actually we have a
> situation where there are two tables with same names on different databases,
> and we need to execute a single query accessing both of these tables..
>
> to be precise ..the query would be lets say database1 is on Oracle on NT
> server and database2 is personal oracle on my WINDOWS 95 machine.
>
> select * from ':database1:XYZTable' a, ':database2:XYZTable' b where
> a.fld1 = b.fld1
>
> How could we handle this kind of situation in oracle by the syntax mentioned
> in your response..
>
> Thanks once again for all your help..
> -Ravi
>
> >
> > In the beginning there was Codd. And he said "Let there be SQL" and there
> > was. He looked at it and it was a Good Thing (tm).
> >
> > To cut a long and interesting story short, then came the database vendors
> > and raped and plundered it... :-)
> >
> > Seriously though, SQL implementations are not the same. Vendors do their own
> > things (no real surprises there). For Oracle, drop the quotes (not
> > necessary) from your SQL and replace DATABASE1 with the name of the schema
> > (i.e.. Oracle user) and use a colon to separate the name of the TABLE with
> > the name of the SCHEMA.
> >
> > Example:
> > SELECT * FROM SCOTT.CLIENTS
> >
> > There's a kind of vanilla flavour of SQL. The basic set of ANSI SQL '92
> > standards - minimum conformance I think they call it. If you stick to that
> > then your stuff should work against most SQL db platforms.
> >
> > Oracle SQL has the vanilla flavour, but the chocolate and strawberry flavour
> > is much better. Oracle supplies you with a lot of additional (non-standard
> > of course) SQL extensions that are very powerful. Even to the extend that
> > you can implement IF THEN ELSE type logic in the SELECT part of the SQL
> > statement. Extremely useful when handling VLDBs or VLTBs where you can not
> > resort to the slow cursor based processing.
> >
> > enjoy the ice-cream!
> > Billy
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Oct 18 1998 - 09:21:23 CDT