Menu Home

SQL Developer: ANSI/Oracle Joins toggle

The ability to switch between ANSI and Oracle style joins was introduced in SQL Developer 19.2.

How to use

The example will show how a query using the Oracle outer join style can be changed to use the ANSI style.

Highlight the SQL statement

Right click to bring up the context menu and select Refactoring

Select Toggle Ansi/Oracle joins

The query is now changed to use ANSI join style.

Caution. Toggling can be hazardous to your code.

It’s still early days for this feature and people have reported problems. A minor inconvenience is the removal of statement semi-colon. Comments left on Jeff’s post mention other issues so as with any tool know it’s limitations and check any changes it makes to ensure the query is still doing what you expect it to.

Categories: Oracle SQL Developer

oraclefrontovik

Developer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.