ANSI joins - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer ANSI joins

Print Thread

ANSI joins #56687 06/27/17 07:37 PM
Joined: Nov 2016 Posts: 5 Curitiba,PR,Brazil S salles OP Member
OP salles Member S Joined: Nov 2016 Posts: 5 Curitiba,PR,Brazil	Is there any option in PL/SQL Developer 12 to convert the queries written using the old-style joins (using "(+)") to new ANSI joins (using "LEFT OUTER JOIN")?

Re: ANSI joins salles #56694 06/28/17 09:14 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	No, there is no option for this. Marco Kalter Allround Automations

Re: ANSI joins Marco Kalter #56700 06/28/17 02:19 PM
Joined: Nov 2016 Posts: 5 Curitiba,PR,Brazil S salles OP Member
OP salles Member S Joined: Nov 2016 Posts: 5 Curitiba,PR,Brazil	I would like to suggest this very useful implementation and can be obtained from the site www.sqlparser.com Source code is also available (http://www.sqlparser.com/dlaction.p...e=SQL%20Formatter%20with%20source%20code). Thanks for listening.

Re: ANSI joins salles #56705 06/29/17 09:06 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	I have added this to the list of enhancement requests. Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.149s Queries: 14 (0.086s) Memory: 2.5038 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-30 06:48:09 UTC
Valid HTML 5 and Valid CSS