146 reputation
18
bio website
location
age 27
visits member for 1 year, 8 months
seen Jul 6 at 2:50

May
28
revised Converting multiple SQL implicit joins into explicit joins
added 2 characters in body
May
28
comment Converting multiple SQL implicit joins into explicit joins
Hi Ted, could you kindly help me understand your steps 9,10 that I have updated in my question..? Thanks
May
13
revised Converting multiple SQL implicit joins into explicit joins
added 14 characters in body
May
13
comment Converting multiple SQL implicit joins into explicit joins
I have updated by question with my understanding of your algorithm.. It's too long to read :). Here is where I am stuck - for "c.c_id = h.c_id(+)" => c LEFT JOIN h. But above we are not getting all the records of c to participate in the join with h, ..correct?
May
13
revised Converting multiple SQL implicit joins into explicit joins
added 2497 characters in body
May
13
revised Converting multiple SQL implicit joins into explicit joins
added 66 characters in body
May
13
comment Converting multiple SQL implicit joins into explicit joins
Hi @Ted, really appreciate your explanation! Need a few mins to understand how the intermediate joins work..
May
13
comment Converting multiple SQL implicit joins into explicit joins
Hi @siride, as mentioned I am looking for example/guides/formal specs on how to resolve this. Consider: Line 3,4: c LJ h; Line 5,6: h LJ g - now how do I combine these two..? c LJ h <LJ/RJ/IJ> h LJ g - doesn't seem right..
May
13
revised Converting multiple SQL implicit joins into explicit joins
edited title
May
12
revised Converting multiple SQL implicit joins into explicit joins
added 65 characters in body
May
12
revised Converting multiple SQL implicit joins into explicit joins
deleted 120 characters in body
May
10
revised Converting multiple SQL implicit joins into explicit joins
added 104 characters in body
May
10
asked Converting multiple SQL implicit joins into explicit joins
Feb
11
awarded  Notable Question
Feb
3
awarded  Popular Question
Aug
22
revised Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
edited title
Aug
22
accepted Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
Aug
22
comment Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
Thanks for including the link to the documentation Phil! That clears it for me.. as when I run multiple queries in a Program window in PLSQL developer, it is intelligent enough to execute each one separately.
Aug
22
asked Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
Jul
4
awarded  Popular Question