Since I haven’t used Oracle in eons, I had to look up the equivalent syntax to the statement I’ve used in SQL Server.
So I had to do another search. Apparently, the INSERT ALL requires a SELECT statement, so using the dual allows for that syntax without adding crap data you don’t want. So yes, you’ll need it, but it won’t actually do anything other than satisfy the syntax requirement.