2] Download the Oracle SQL Developer Now, we need to download the Oracle SQL Developer installation media and run it to install the utility. To do so, you need to go to developer.oracle.com.

Does 3.23 support derived tables (aka inline views)? If so, plug the SELECT statement that would have generated the temp. table directly into your main query, and Bob's your uncle.