Skip to content
Advertisement

Oracle SQL insert into with With clause

I’m new to sql, so maybe it is a dumb question, but is there any possibility to use With clause with Insert Into? Or are there any common workarounds? I mean something like this:

Thx!

My example is too dummy, so I add some extended code (thx for the answers so far).

Advertisement

Answer

You may use as many ‘helper_tables’ as you wish.

With this in mind, you may be able to do all of your joins via normal joining of the tables to the master table

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement