Ansi Joins not supported by query builder or beautifier

[Petros Amiridis]

Hi!

If I am not mistaken, ansi joins are not supported by either query builder or beautifier. Do you have any plans of supporting it?

For example:

select *
from a join b on a.id = b.foreign_id
join c on a.c_id = c.id
where a.criteria = somevalue

1) Query builder does not let me choose if I want the ansi join or the other one

2) Beautifier makes the from one BIG line

Thanx.

 

[ScottMattes]

Is that even legal in Oracle?

 

[lspence8]

Yup it is in v9 and

 

[Marco Kalter]

We'll add support in 6.0.

 

[Stew Stryker]

Late reply to this thread...

Nice job adding ANSI Join support to the Beautifier. You're a step ahead of Quest Software's SQL/Navigator 4.0.3 in that regard.

Should the Query Builder also support it? If so, is that a feature I need to turn on? Version 6.0.2.880 doesn't recognized the JOIN statement, though it'll handle the Oracle syntax just fine.

I've just started checking out Developer a couple days ago, having used SQL/Navigator for about 3 hours every day for the past 3 years. So far, I'm VERY impressed in the comparison. I think Developer will make me a MUCH more productive programmer! Now I just have to convince my boss to spend the $$$!

Thanks,

Stew

p.s. If someone at Allround wants to email me, I'd be happy to share what I see are advantages over SQL/Nav.

 

[Marco Kalter]

So far, I'm VERY impressed in the comparison. I think Developer will make me a MUCH more productive programmer! Now I just have to convince my boss to spend the $$$!

Thanks . The Return On Investment time should be fairly short.

p.s. If someone at Allround wants to email me, I'd be happy to share what I see are advantages over SQL/Nav.

That is always useful to know. Perhaps you can e-mail me at marco.kalter@allroundautomations.com?

 

[Jean-Paul Finne]

What about the query builder and ansi join ?

 

[Marco Kalter]

This will be added in a future PL/SQL Developer release, hopefully 6.1.