• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Urgent Oracle SQL Question (INNER JOIN)

the (+) notation is still messy

A well formatted select statement using the "inner join" "left out join" notation is much easier to read and to achieve consistant results with.
Code:
table_a a
   inner join table_b b
      on a.col1 = b.col1
     and a.col2 = b.col2
   inner join table_c c
      on a.col1 = c.col1
     and a.col2 = c.col2
    left outer join table_d d
      on d.col1 = a.col3
    left outer join table_e e
      on b.col3 = e.col1
 
Last edited: 12:25
I'll bear that in mind for when Oracle migrate the eBusiness Suite away from the Oracle database :)

After all, there is no other database but Oracle.

We use sybase :tantrum: - I miss oracle so much.

The thing I have trouble with on outer joins is which side to add the "*" - I always get it wrong first time!
 
We use sybase :tantrum: - I miss oracle so much.

The thing I have trouble with on outer joins is which side to add the "*" - I always get it wrong first time!

I miss Oracle as well, current client is Sybase hadnt used it for years always had been Oracle, all I can is Sybase is such a pile of sh8t compared to Oracle. One of the DBs I connect to is Sybase Adaptive Server IQ and I cant find any sql tool, apps like Toad etc that will run correctly with it, I have to use some sh*tty IQ sql interface.

Sybase poo, Oracle great
 
I miss Oracle as well, current client is Sybase hadnt used it for years always had been Oracle, all I can is Sybase is such a pile of sh8t compared to Oracle. One of the DBs I connect to is Sybase Adaptive Server IQ and I cant find any sql tool, apps like Toad etc that will run correctly with it, I have to use some sh*tty IQ sql interface.

Sybase poo, Oracle great

I did have a tool for connecting to any of the major database products.
I'll see if i can find it!

edit:
Got it: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp
 
Last edited: 13:51
Who was it that didn't get the gig because they didn't use the ANSI standard in one of the technical tests?

Someone on here did it (but eventually got the gig anyway).
 
Who was it that didn't get the gig because they didn't use the ANSI standard in one of the technical tests?

Someone on here did it (but eventually got the gig anyway).

I remember that post. Didn't know they got the gig eventually. Good that common sense provailed.
 
Once you start writing more complex queries you'll understand the benefits
Once I started writing more complex queries, I began to understand the benefits of not writing more complex queries.
 

Advertisers

Back
Top