Re: left outer join

No doubt you will find Oracle's multiversioning a huge shock when you discover it.

And I find it an emotional issue ... as I have spent thousands of hours, in panic situations, fixing applications written by people who don't read manuals and believe that whatever Bill Gates does is the standard.

Daniel Morgan

Andre Grosse wrote:

> Jim Kennedy wrote:
>
> > rownum< N is not the same as top N. try a statement that has an order by
> > for example.
>
> i know, with orderBy i have to use a subselect to change the
> rownum/orderBy comoutation order (or something with rank())
> i make that properly, but dont write here all in full detail.
>
> i only wished to know if oracle works correctly with left outer joins,
> if the on-condition never is true. mssql computes it correctly in my
> opinion, oracle not. shouldnt get null result?!
>
> > Toad is nice but you also have tkprof and explain plan from Oracle(comes
> > with the db)
>
> thX, will see
>
> > Danial is correct. Seen too many MSSQL conversions and not enough thought
> > about how both RDBMS's are different (concurrency and transaction models are
> > very different for example, MSSQL developers often uses a lot of temp
> > tables, rare to use them in Oracle development. sequences vs auto id
> > fields, ref cursor etc.
> > Jim
> >
>
> fortunately i only have to read in that database...so a lot of stuff
> mentioned here isnt importand for that job.
> (database automatically replicated from mssql with transparent gateway)
>
> --
> Andre Grosse
Received on Wed Jan 16 2002 - 06:49:32 CST